有哪位大虾对MySql比较熟悉呀,我怎么连接不上数据库啊? 去下载一个MySql的jdbc驱动,加到classpath中,按照教材上说的方法没问题 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 去下载:mm.mysql-2.0.4-bin.jar,放到你的CLASSPATH中 <%@page contentType="text/html;charset=gb2312"%> <%//声名 java.sql.Connection sqlConn; java.sql.Statement sqlStmt; java.sql.ResultSet sqlRst; //regiester jdbc driver Class.forName("org.gjt.mm.mysql.Driver").newInstance();System.out.println("OK! JDBC Driver For MySQL Loaded.");//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//connect to the database sqlConn=java.sql.DriverManager.getConnection ("jdbc:mysql://localhost/test","root","root");System.out.println("OK!Connect to MySQL DBMS.");//create the driver handle sqlStmt=sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY); System.out.println("OK!Resultset setting Completed!");//excute sql sqlRst=sqlStmt.executeQuery("select * from whir_user"); System.out.println("OK!Query Completed!");%> <html> <head> <title>Windows-JSP-JDBC-MSSQL TESTING </title> </head> <body> <table border="1" cellspace ="0" align="center"> <tr> <th>title </th> <th>title </th> <th>title </th> <th>title </th> <th>title </th> <th>title </th> <th>title </th> </tr> <% while(sqlRst.next()) {%> <tr> <td> <%=sqlRst.getString(1)%></td> <td><%=sqlRst.getString(2)%></td><td><%=sqlRst.getString(3)%></td><td><%=sqlRst.getString(4)%></td><td><%=sqlRst.getString(5)%></td><td><%=sqlRst.getString(6)%></td><td><%=sqlRst.getString(7)%></td></tr> <%}%> </table> </body> </html> <% sqlRst.close(); sqlStmt.close(); sqlConn.close(); %> 消除Jcreator的设定信息 JDK 安装问题 要求在括号中填空 能够跨异构平台与其他实体进行交互的技术有哪些? 一个illegal character in URL 的问题.大哥们帮帮忙吧! JPanel 中关于Graphics的问题 100分求热心人,请问怎样使一副图像在指定大小panel内显示??? 怎么可以得到一个JPanel下的所有JTextField的所有变量名。 请问大虾,在Jcreator Pro中如何对JDK进行设置? jbuilder4 太慢了!!!! 一道摸拟题求解! 那位可以讲讲推拉技术的实现方法?
<%
//声名
java.sql.Connection sqlConn;
java.sql.Statement sqlStmt;
java.sql.ResultSet sqlRst;
//regiester jdbc driver
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
System.out.println("OK! JDBC Driver For MySQL Loaded.");
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//connect to the database
sqlConn=java.sql.DriverManager.getConnection
("jdbc:mysql://localhost/test","root","root");
System.out.println("OK!Connect to MySQL DBMS.");
//create the driver handle
sqlStmt=sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
System.out.println("OK!Resultset setting Completed!");
//excute sql
sqlRst=sqlStmt.executeQuery("select * from whir_user");
System.out.println("OK!Query Completed!");
%>
<html>
<head>
<title>Windows-JSP-JDBC-MSSQL TESTING </title>
</head>
<body>
<table border="1" cellspace ="0" align="center">
<tr>
<th>title </th>
<th>title </th>
<th>title </th>
<th>title </th>
<th>title </th>
<th>title </th>
<th>title </th> </tr>
<% while(sqlRst.next()) {%>
<tr>
<td> <%=sqlRst.getString(1)%></td>
<td><%=sqlRst.getString(2)%></td>
<td><%=sqlRst.getString(3)%></td>
<td><%=sqlRst.getString(4)%></td>
<td><%=sqlRst.getString(5)%></td>
<td><%=sqlRst.getString(6)%></td>
<td><%=sqlRst.getString(7)%></td>
</tr>
<%}%>
</table>
</body>
</html>
<%
sqlRst.close();
sqlStmt.close();
sqlConn.close();
%>