下载个mysql的jdbc驱动程序
然后加载到classpath中,
连接数据库的代码如下:
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname","","");
Statement stmt=conn.createStatement();
String sql="select * from dbname";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
}
%>
conn=java.sql.DriverManager.getConnection("jdbc:mysql://数据库服务器IP:3306/数据源名?useUnicode=true&characterEncoding=gb2312","user",pass");
用jsp测试。
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb";
//mydb为你的数据库
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from tongxue"; //你的数据库中的表
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
在tomcat下用jsp访问,提示错误如下:
“驱动错误: org.gjt.mm.mysql.Driver ”
mysqltest.jsp如下:
<html>
<head>
<title>MySQL连接测试</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<center><p><h4><font color="blue">建立连接</font></h4></p>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<%
String DriverStr = "org.gjt.mm.mysql.Driver";
String ConnStr = "jdbc:mysql://localhost:3306/my_test?useUnicode=true&characterEncoding=gb2312";
String user="zhangxj";
String password="it474150";
try
{
Class.forName(DriverStr).newInstance(); Connection databaseConnection = DriverManager.getConnection(ConnStr,user,password);
out.println("数据库连接成功!");
databaseConnection.close();
}
catch(ClassNotFoundException e)
{
out.println("驱动错误: " + e.getMessage());
}
catch (SQLException E)
{
out.println("SQLException: " + E.getMessage());
out.println("SQLState: " + E.getSQLState());
out.println("VendorError: " + E.getErrorCode());
}
%> </center></body>
</html>
请大家帮忙!急!!