jsp数据库连接方法及实例代码.docVIP

实验七 JDBC数据库连接实验 一、实验目的实验实验‘11’,’李勇’,‘软件工程’’1990-5-6’);] [insert into student values(‘11’,’王敏’,‘计算机科学与技术’’1991-1-2’);] 配置Jsp访问数据库的应用程序环境。解 压mysql-connector-java-5.0.8.zip,分别找到mysql-connector-java-5.0.8-bin.jar与mysql-connector-java-5.0.8-bin-g.jar；将mysql-connector-java-5.0.8-bin.jar拷贝到D:\软件安装\apache-tomcat-7.0.42\lib目录下；将mysql-connector-java-5.0.8-bin-g.jar拷贝到C:\Program Files\Java\jdk1.7.0_04\lib目录下；在C:\Program Files\Java下建立mysqlforjdbc目录，将mysql-connector-java-5.0.8-bin.jar拷贝到该目录；设置环境变量，在path末尾添加%JAVA_HOME%\lib\mysql-connector-java-5.0.8-bin-g.jar;C:\Program Files\Java\mysqlforjdbc\mysql-connector-java-5.0.8-bin.jar 设计Jsp页面，进行数据库连接和测试 %@page language=java contentType=text/html; charset=gb2312 errorPage=% %@page import=java.sql.* % htmlheadmeta http-equiv=Content-Type content=text/html; charset=gb2312 /headbody% String url=jdbc:mysql://localhost/Student; String userName=root; String password=; String sql=null;Connection conn=null;Statement stmt=null; try{ Class.forName(com.mysql.jdbc.Driver); }catch(ClassNotFoundException e){ out.println(加载驱动器类时出现异常);} try{ conn=DriverManager.getConnection(url,userName,password); stmt=conn.createStatement(); sql=”SELECT*FROM student”; ResultSet rs=stmt.executeQuery(sql);% table width=740 border=1 cellpacing=0 cellpadding=6tr td width=15 align=center valign=middle编号/tdtd width=60 align=center姓名/td td width=140 align=center专业/tdtd width=80 align=center出生日期/td/tr %while(rs.next()){ int id=rs.getInt(1); String name=rs.getString(2); String mayjor=rs.getString(3); String birthday=rs.getString(4);% tr td height=40 align=center valign=middle%=id%/td td align=center valign=middle%=name%/td td valign=middle%=mayjor%/td td align=center valign=middle%=birthday%/td/tr%} rs.close();stmt.close(); }catch(SQLException e){ out.println(出现SQLException异常);} finally{ try{if(conn!=null) conn.close(); }catch(SQLException e){ out.println(关闭数据库连接时出现异常);}}% /table/body/html 四、实验 分析和总结 通过这次试验，我了解了通过Mysql数据库的操作、JDBC数据库连接配置及实现，掌握Mysql数据库的基本使用方法。开始进行与mysql的连接