实验十二 JDC 数据库编程(I).doc

§12 JDBC 数据库理解和掌握 JDBC 的结构以及 JDBC 与数据库应用编成之间的关系，掌握 DriverManage 、 Connection 、 Ststement 等数据库类的常用方法。Connection conn = null; Statement stmt = null; ResultSet rs = null; try{ Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); } catch(ClassNotFoundException ce){ out.println(ce.getMessage()); } try{ conn=DriverManager.getConnection(jdbc:odbc:grade,,); stmt=conn.createStatement(); rs=stmt.executeQuery(SELECT * FROM grade); while(rs.next()){ System.out.print(rs.getString(学号)); System.out.print(rs.getString(姓名)); System.out.print(rs.getString(语文)); System.out.print(rs.getString(数学)); System.out.print(rs.getString(英语)); System.out.println(); } } catch(SQLException e){ System.out.println(e.getMessage()); } finally{ stmt.close(); conn.close(); } 2、数据库访问层，单独写成一个类或几个类(访问数据库代码) (1) 、表语句示例： create table users( uname varchar(10) primary key, upwd varchar(10) ); insert into users values(admin,1234); insert into users values(zhou,zhou); (2)、数据库访问层： package dao; import java.sql.*; public class CustomerDao { private String url=jdbc:mysql://127.0.0.1:3306/support; private String driver=com.mysql.jdbc.Driver; /*验证用户名与密码函数*/ public boolean validate(String uname,String upwd){ boolean flag=false; try{ Class.forName(driver); Connection con=DriverManager.getConnection(url,root,4846); Statement cmd=con.createStatement(); String sql= select * from users;// where uname=+uname+; ResultSet rs=cmd.executeQuery(sql); if(rs.next()) if(rs.getString(1).equals(upwd)) flag=true; con.close(); }catch(Exception ex){ flag=false; } return flag; } } (3)、用户界面(UI层)调用 package ui; import dao.CustomerDao; import java.awt.*; import java.awt.event.*; import javax.swing.*; public class MyFrm extends JFrame implements ActionListener{//从JFrame继承 /*声明界面需要使用的控件*/ JLabel lbl_name =new JLabel(用户名); JLabel lbl_pwd =new JLabel(密码); JText