JAVA实验报告-实验八

院（系）计算机学院专业计算机科学与技术班级计科2班姓名学号同组人且_________________________________________________________________实验室S4305组号日期课程Java程序设计指导教师成绩实验项目编号8103200408实验项目名称访问数据库

一、实验目的熟悉并掌握JDBC编程

二、实验环境W indows XP操作系统EcIipse,MySQL

三、实验原理

1.在MySq I下创建一个数据库mydb,并创建student.

2.编制一个简单的JDBC的程序，实现JavaWeb下的数据库基本操作

3.完成插入，更新，修改，查询的操作

四、算法设计【任务一】登录，验证行号和密码JDBCo数据库用MySql

五、主要代码及说明【任务一】Mycnn类:import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public classMycnn{public staticvoid mainString[]args{Connection cnn=null;Statement stmt=null;ResultSet rs=null;tryClass.forName”com・mysqlJdbc.Driver;String url=jdbc:mysql://

127.

0.

0.l:330xyy”;String user=root”；String password=123456”；cnn=DriverManager.getConnectionurl,user,password;stmt=cnn.createStatement;rs=stmt.executeQuery,,select*from tb_booksH;while rs.next{System.out.printlnrs.getString,,authorH;}}catch Exceptione{e.printStackTrace;if rs!=null{try rs.close;}catch SQLExceptione{e.printStackTrace;if stmt!=null{trystmt.close;}catch SQLExceptione{//TODO Auto-generated catchblock e.printStackTrace;if cnn!=null{trycnn.close;}catch SQLExceptione{e.printStackTrace;}}}Logi nFrame类:import java.awt.Color;import java.awt.Container;import java.awt.HeadlessException;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JTextField;public classLoginFrame extendsJFrame implementsActionListener{JLabeljl01=newJLabel,,用户名:；J Labeljl02=new JLabel密码11;JTextField username=new JTextField8;JTextField userpwd=new JTextField8;J Buttonb=new JButton“登录；public LoginFramethrows HeadlessException{super;fun;public voidfun{setLocation100,100;setSize300,300;Container c=getContentPane;c.setLayoutnull;jlOl.setBoundsfSO,50,100,40;jl02,setBounds50,120,100,40;username.setBoundsflJO,50,100,40;userpwd.setBounds170,120,100,40;b.setBounds100,180,100,40;c.addjlOl;c.addjl02;c.addusername;c.adduserpwd;b.addActionListenerthis;c.addb;setDefaultCloseOperationEXIT_ON_CLOSE;}public staticvoid mainString[]args{LoginFrame mj=new LoginFrame;mj.setVisibletrue;}public voidactionPerformedActionEvent e{String name=username.getText;String pwd=userpwd.getText;ifuserDao.isMembername,pwd{this.dispose;SuccessFrame sf=new SuccessFrame;sf.setVisibletrue;userDao类:import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import com.mysql.jdbc.PreparedStatement;public classuserDao{public staticConnection getCon{Connection cnn=null;try{Class・forNamecom.mysql・jdbc.Driver;String url=Hjdbc:mysql://

127.

0.

0.1:3306/xyyH;String user=root;String password=123456”；cnn=DriverManager.getConnectionurl,user,password;}catch Exceptione{//TODO Auto-generated catchblock e.printStackTrace;return cnn;}public staticboolean isMemberStringname,String pwd{boolean flag=false;Connection cnn=getCon;Statement stmt;trystmt=cnn.createStatement;String sql=Hselect*from userwhere username=+name+”and userpwd=+pwd+””;ResultSet rs=stmt.executeQuerysql;ifrs.next{flag=true;}ifrs!=null{rs.close;}ifstmt!=null{rs.close;}ifcnn!=null{rs.close;}}catch SQLExceptione{e.printStackTrace;return flag;SuccessFrame类import java.awt.Color;import java.awt.Container;import java.awt.HeadlessException;import javax.swing.JFrame;import javax.swing.JLabel;public classSuccessFrame extendsJFrame{public SuccessFramefthrows HeadlessException{superf;fun;}public voidfun{J Labeljl=new JLabel热烈欢迎！！！”；setLocation100,100;setSize500,500;Container c=getContentPane;c.setBackgroundColor.yellow;c.addjl;setDefaultCloseOperationEXIT_ON_CLOSE;

六、实验小结通过本次上机，将所学知识与数据库有机结合起来，知道了java连接访问数据库的一般过程

①找到对应jar包，把其导入项目

②Connect ion3Statement/Prepared Statement

④Resu11Set

⑤按照堆栈顺序依次关闭数据库对象。