电脑常规知识——java数据库编程.docx

java数据库编程数据查询Query.java package Query; import java.sql.*; public class Query public static void main(String args) try /加载JDBC驱数据库动程序 Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); System.out.println (成功加载JDBC-ODBC驱动程序); catch (ClassNotFoundException ee) System.out.println (加载JDBC-ODBC驱动程序失败); System.out.println (ee.getMessage (); return; try /建立与数据源student的连接 Connection conn=DriverManager.getConnection(jdbc:odbc:student,); System.out.println(连接student.mdb数据库成功); Statement Stmt=conn.createStatement(); / 查询记录 ResultSet rs=Stmt.executeQuery(select * from student1); / 定位到第一条记录 boolean moreRecords = rs.next(); if ( ! moreRecords ) / 如果没有记录，则显示一条消息 JOptionPane.showMessageDialog(null,结果集中无记录 ); return; / 显示记录 do String id=rs.getString(s_id); String name=rs.getString(name); String sex=rs.getString(sex); Date bir=rs.getDate(birthday) ; String c_id=rs.getString(class_id); String mem=rs.getString(memory); System.out.println(学号 +id+姓名 +name+性别 +sex+生日 +bir+班级 +c_id+简历 +mem); while(rs.next(); conn.close(); catch(SQLException e1) System.out.println (发送(sql) 学生.mdb数据库失败); System.err.println(SQLException: + e1.getMessage(); return; 插入行Insert.java package Insert; import java.sql.*; public class Insert public static void main(String args) try /加载JDBC驱数据库动程序 Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); System.out.println (成功加载JDBC-ODBC驱动程序); catch (ClassNotFoundException ee) System.out.println (加载JDBC-ODBC驱动程序失败); System.out.println (ee.getMessage (); return; try /建立与数据源student的连接 Connection conn=DriverManager.getConnection(jdbc:odbc:student,); System.out.println(连接student.mdb数据库成功); Statement Stmt=conn.createStatement(); /插入记录 Stmt.executeUpdate(insert into class1 values(090901,09计算机信息); System.out.println(插入记录成功); conn.close(); catch(SQLException e1) System.out.println (发送(sql)student.mdb数据库失败); System.err.println(SQLException: + e1.getMessage(); return; 删除数据Delete.java package Delete; import java.sql.*; public class Delete public static void main(String args) try /加载JDBC驱数据库动程序 Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); System.out.println (成功加载JDBC-ODBC驱动程序); catch (ClassNotFoundException ee) System.out.println (加载JDBC-ODBC驱动程序失败); System.out.println (ee.getMessage (); return; try /建立与数据源student的连接 Connection conn=DriverManager.getConnection(jdbc:odbc:student,); System.out.println(连接student.mdb数据库成功); Statement Stmt=conn.createStatement(); / 删除记录 String sqlstr=delete from class1; Stmt.executeUpdate(sqlstr); System.out.println(删除记录成功); conn.close(); catch(SQLException e1) System.out.println (发送(sql)student.mdb数据库失败); System.err.println(SQLException: + e1.getMessage(); return; 修改数据Update.java package Update; import java.sql.*; public class Update public static void main(String args) try /加载JDBC驱数据库动程序 Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); System.out.println (成功加载JDBC-ODBC驱动程序); catch (ClassNotFoundException ee) System.out.println (加载JDBC-ODBC驱动程序失败); System.out.println (ee.getMessage (); return; try /建立与数据源student的连接 Connection conn=DriverManager.getConnection(jdbc:odbc:student,); System.out.println(连接student.mdb数据库成功); Statement Stmt=conn.createStatement(); / 修改记录 String sqlstr=update score1 set score1=100,score2=99; Stmt.executeUpdate(sqlstr); Sys