关于jsp连接mysql问题帮我看下问题出在哪,谢谢!!

来源:百度知道 编辑:UC知道 时间:2024/05/25 14:58:36
Bean代码:
package database;
import java.sql.*;
public class sqlbean {
public String query_statement;
public ResultSet result=null;
public Connection conn;

public void setQuerystatement(String query_statement)
{
this.query_statement=query_statement;
}

public void setConnection(String driverName ,String jdbcURL,
String username,String passwd) throws Exception
{
Connection conn1;
Class.forName(driverName);
conn1=DriverManager.getConnection(jdbcURL, username, passwd);
conn1.setAutoCommit(false);
this.conn = conn1;
}

public ResultSet getResult()
{
try
{
PreparedStatement select_stm=conn.prepareStatement(query_statement,
java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
result=select_stm.executeQuery();
}
catch(Exception e)
{
Sy

晕了,你用的是mysql,你给加载的是sqlserver类驱动,应该加mysql驱动

改为:
sqltest.setConnection("org.gjt.mm.mysql.Driver","jdbc:mysql://localhost:3306/net-hd","root","root");

你的程序在哪里出现错误?没有说清楚啊。^_^