10-数据库编程.ppt

NCEPU conn.setAutoCommit(false); ?? String?sql?=?insert?into?survey(id,?name)?values(?,?); PreparedStatement?pstmt?=?conn.prepareStatement(sql); pstmt.setString(1,?1); pstmt.setString(2,?name1); pstmt.addBatch(); pstmt.setString(1,?2); pstmt.setString(2,?name2); pstmt.addBatch(); pstmt.executeBatch(); ?mit(); ?? PreparedStatement—批处理 Statement stmt = conn.createStatement(); stmt.addBatch(insert into dept2 values (51, 500‘)); stmt.addBatch(insert into dept2 values (52, ‘580)); stmt.addBatch(insert into dept2 values (53, ‘600’)); stmt.executeBatch(); stmt.close(); public class TestPreparedStatement{ public static void main(String[] args) { String name=null; String sex=null; Connection conn=null; PreparedStatement pstmt=null; try{ Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); conn=DriverManager.getConnection(jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=.\\shop.mdb,,); Scanner sc=new Scanner(System.in); name=sc.next(); sex=sc.next(); pstmt=conn.prepareStatement(insert into table1 values (?,?)); pstmt.setString(1,name); pstmt.setString(2,sex); pstmt.executeUpdate(); } catch (ClassNotFoundException e) { JOptionPane.showMessageDialog(null, e.getMessage()); e.printStackTrace(); } catch (SQLException e) { JOptionPane.showMessageDialog(null, e.getMessage()); e.printStackTrace(); } finally{ try{ pstmt.close(); conn.close(); } catch (SQLException e) { JOptionPane.showMessageDialog(null, e.getMessage()); e.printStackTrace(); } } }} NCEPU 使用JTable表格显示数据库查询结果 任务2 设计一个GUI界面，使用JTable表格显示user表中的数据信息。 while (rs.next()){ //遍历查询结果 rowData[count][0]=rs.getString(name); //初始化数组内容 rowData[count][1]=Integer.toString(rs.getInt(age)); rowData[count][2]=rs.getString(sex); rowData[count][3]=rs.getString(email); coun