- 论坛徽章:
- 0
|
// try {
Class.forName("org.gjt.mm.mysql.Driver");
java.sql.Connection connect = java.sql.DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/mysql","root","123456");
//连接URL为 jdbc:mysql//服务器地址/数据库名
//后面的2个参数分别是登陆用户名和密码
out.println("Success connect Mysql server!");
java.sql.Statement stmt = connect.createStatement();
java.sql.ResultSet rs = stmt.executeQuery("select * from db");
while (rs.next()) {
out.println(rs.getString("Db"));
}
// }
// catch (Exception e) {
// out.print("get data error!");
// e.printStackTrace();
// }
%>
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u2/71462/showart_1005331.html |
|