还剩2页未读,继续阅读
文本内容:
实验报告一软工班—程银超201026810304_1001数据库表格及记录:创建数据库SQL:--7Jr-JTJ-----------------------------------------------------------------------------Jr-7T.nysql createdatabase Testdb;Query OK,1row affected
0.03sec创建数据库表SQL:nysql createtable rgusersuseridint,username char16,passuord char16;Query OK,0rowsaffected
0.11sec插入几条记录:nysql insertinto rgusersualues”/eye/123456789’〉;Query OK,1rovi affected
0.06secnysql insertinto rgusersualuesl,J tomJ123456789*;Query OK,1row affected
0.05secnysql insertinto rgusersualuesd,J jinJ,9123456789J;Query OK,1row affected
0.03secnysql insertinto rgusersualuesl,9lucy,,9123456789J;Query OK,1row affected
0.03secnysql insertinto rgusersualuesd,9dauid,,9123456789J;Query OK,1row affected
0.05sec二.使用访问数据库结果:JDBC蒯娜螂岫II WHX切师画血网娜)喇嫄脚§▼娜卜|;原翻f MexR-Eg]嬲Q解-0MbMQlovet魏颠[露枫HA能懈W,0i TestMysqlxeye tomjin lucydavid代码%@page language=java contentType=text/html;charset=gbkpageEncoding=gbk%!DOCTYPE htmlPUBLIC-//W3C//DTD HTML
4.01Transitional//ENhtmlheadmeta http-equiv=Content-Type content=text/html;charset=gbktitleTest Mysql/title/headbody%@page import=java.sql.*%%Class.forNamecom.mysql.jdbc.Driver;Connection conn=DriverManager.getConnectionjdbc:mysql://localhost:3306/Testdb,root,;Statement st=conn.createStatement;st.setMaxRows20;String sqlStr=select*from rgusers;ResultSet rs=st.executeQuerysqlStr;whilers.next{%%=rs.getStnngusername%br%rs.close;st.close;conn.close;%/bodyx/html使用连接池技术访问数据库结果:©iTestMysql•搜狗高速浏览器账户U文件D查看国蛇IOAIDL尸Shttp://localhost:8080/dbexample/TestMysql.jsp0兼容「;后458踪^!农业强行上工商银行叵爱奇艺-中计首页-E度需DOTA视频画李毅包百❹人人网-©Yumiko04©lov的林G我的首页
⑥博客园-YYeTs人人6妻B国TestMysqleye tomjim lucydavid代码%@page language=java contentType=text/html;charset=gbkpageEncoding=gbk%htmlheadmeta http-equiv=Content-Type content=text/html;charset=gbktitleTest Mysql/title/headbody%@page import=java.sql.*%%@page import=,javax.sql.*%%DataSource dataSource;Context context=new lnitialContext;dataSource=DataSourcecontext.lookupjava:comp/env/jdbc/Testdb;Connection dbConnection=null;dbConnection=dataSource.getConnection;Statement st=conn.createStatement;st.setMaxRows20;String sqlStr=select*from rgusers;ResultSet rs=st.executeQuerysqlStr;whilers.next{%%=rs.getStringusername%br%}rs.close;st.close;conn.close;%/body/html实验收获及碰到的问题问题在下真是难打啊!Mysql dos刚开始不知道该怎么用,后来通过一系列方法才做出了数据库,跟以前的其他数据dos库的图形界面有很大差异,一步错步步错!。