mysql+myeclipes+win7的数据库测试Word格式文档下载.docx
《mysql+myeclipes+win7的数据库测试Word格式文档下载.docx》由会员分享,可在线阅读,更多相关《mysql+myeclipes+win7的数据库测试Word格式文档下载.docx(15页珍藏版)》请在冰豆网上搜索。
![mysql+myeclipes+win7的数据库测试Word格式文档下载.docx](https://file1.bdocx.com/fileroot1/2022-11/26/2160bd1e-f210-4615-9d6d-3f06c3389adf/2160bd1e-f210-4615-9d6d-3f06c3389adf1.gif)
上图为一个可视化的与SQL结合的工具
导入包:
my-sql-connector-java-3.1.10-bin.jar
代码如下:
packagecom.jdbc;
importjava.sql.*;
importjava.sql.Connection;
importjava.sql.DriverManager;
publicclassTestConn{
publicstaticvoidmain(String[]args){
//TODOAuto-generatedmethodstub
Stringdrv="
org.gjt.mm.mysql.Driver"
;
Stringurl="
jdbc:
mysql:
//localhost:
3306/Demo"
Stringusr="
root"
Stringpwd="
123456"
Stringsql="
select*fromusers"
try
{
Class.forName(drv).newInstance();
Connectionconn=DriverManager.getConnection(url,usr,pwd);
Statementstm=conn.createStatement();
ResultSetrs=stm.executeQuery(sql);
ResultSetMetaDatarsmd=rs.getMetaData();
intcols=rsmd.getColumnCount();
while(rs.next())
for(inti=1;
i<
=cols;
i++){
Stringfield=(String)(rsmd.getColumnName(i));
Stringvalue=(String)(rs.getString(i));
System.out.println(field+"
="
+value);
}
rs.close();
stm.close();
conn.close();
catch(Exceptione)
e.printStackTrace();
System.out.print(e);
}
}