我用JAVA与JSP做系统，连接好了数据库怎么用insert into插入数据到数据库中

最简单的方法是 在页面里面写java代码 获得连接 插入数据。 <% java code.... %>

应该用Statement的executeUpdate方法，不是executeQuery

像你这样的问题

别人肯定会给你贴代码 关键的是你能否看懂

所以你要去学习jsp

学习jsp

传智播客下载视频 魔了在线下载视频

你还没有写业务逻辑和DAO怎么可以添加数据哪，通过表示层把数据传到控制层在调用业务逻辑层做业务处理，处理完调用DAO层把数据放入存储介质中也就是(数据库中)，你可以在DAO层做对数据库的增删改查四个操作。

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement;

public class DBTools { // 定义一个方法，用来得到一个"新的"连接对象 public static Connection getConnection() { Connection conn = null; String driverName = "oracle.jdbc.driver.OracleDriver"; String url = "jdbc:oracle:thin:@localhost:1521:ora9i"; String userName = "scott"; String passWord = "tiger"; try { Class.forName(driverName); conn = DriverManager.getConnection(url,userName,passWord ); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } return conn; } public static void closeConn(Connection conn) { try { if(conn != null) { conn.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void closeState(Statement state) { try { if(state != null) { state.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void closeRs(ResultSet rs) { try { if(rs != null) { rs.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }

import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList;

import com.tianyitime.notebook.support.userPO.UserPO; import com.tianyitime.notebook.support.util.DBTools;

public class UserDAO { // 新增user public void saveUserInfo(UserPO upo) { Connection conn = null; Statement state = null; try { conn = DBTools.getConnection(); state = conn.createStatement(); String sql = "insert into notebook_user values ("+getMaxId()+",'"+upo.getYhm()+"','"+upo.getEmail()+"','"+upo.getContent()+"')"; //System.out.println(sql); state.executeUpdate(sql); } catch (Exception ex) { // TODO Auto-generated catch block ex.printStackTrace(); } finally { DBTools.closeState(state); DBTools.closeConn(conn); } } //得到一个数据库中当前Id的最大值 private int getMaxId() { Connection conn = null; Statement state = null; ResultSet rs = null; int maxId = 0; try { conn = DBTools.getConnection(); state = conn.createStatement(); String sql = "select max(id) maxId from notebook_user"; rs = state.executeQuery(sql); //从resultset对象中将数据取出 if(rs.next()) { maxId = rs.getInt("maxId"); } } catch (Exception ex) { // TODO Auto-generated catch block ex.printStackTrace(); } return ++maxId; } // 得到所有的记录 public ArrayList getUserInfo() { Connection conn = null; Statement state = null; ResultSet rs = null; UserPO upo = null; ArrayList al = new ArrayList(); try { conn = DBTools.getConnection(); state = conn.createStatement(); String sql = "select * from notebook_user"; rs = state.executeQuery(sql); //从resultset对象中将数据取出 while(rs.next()) { upo = new UserPO(); int id = rs.getInt("id"); String yhm = rs.getString("yhm"); String email = rs.getString("email"); String content = rs.getString("content"); upo.setId(id); upo.setYhm(yhm); upo.setEmail(email); upo.setContent(content); //将改对象放入已经创建好的集合类对象ArrauyList al.add(upo); } } catch (Exception ex) { // TODO Auto-generated catch block ex.printStackTrace(); } finally { DBTools.closeRs(rs); DBTools.closeState(state); DBTools.closeConn(conn); } return al; }

// 删除一条user记录 public void deleteUserInfo(int id) { Connection conn = null; Statement state = null; try { conn = DBTools.getConnection(); state = conn.createStatement(); String sql = "delete from notebook_user where id="+id; //System.out.println(sql); state.executeUpdate(sql); } catch (Exception ex) { // TODO Auto-generated catch block ex.printStackTrace(); } finally { DBTools.closeState(state); DBTools.closeConn(conn); } } // 根据给定的信息得到记录 public ArrayList getUserInfoByInfo(String name,String email,String content) { Connection conn = null; Statement state = null; ResultSet rs = null; UserPO upo = null; ArrayList al = new ArrayList(); try { conn = DBTools.getConnection(); state = conn.createStatement(); String sql = "select * from notebook_user where 1=1 "; if(!"".equals(name) && name != null) { sql += " and yhm like '%"+name+"%'"; } if(!"".equals(email) && email != null) { sql += " and email = '"+email+"'"; } if(!"".equals(content) && content != null) { sql += " and content like '%"+content+"%'"; } sql+=" order by id desc"; rs = state.executeQuery(sql); //从resultset对象中将数据取出 while(rs.next()) { upo = new UserPO(); int id = rs.getInt("id"); String yhm = rs.getString("yhm"); String femail = rs.getString("email"); String fcontent = rs.getString("content"); upo.setId(id); upo.setYhm(yhm); upo.setEmail(femail); upo.setContent(fcontent); //将改对象放入已经创建好的集合类对象ArrauyList al.add(upo); } } catch (Exception ex) { // TODO Auto-generated catch block ex.printStackTrace(); } finally { DBTools.closeRs(rs); DBTools.closeState(state); DBTools.closeConn(conn); } return al; }

}