求jsp问题!!!100分。
来源:百度知道 编辑:UC知道 时间:2024/05/14 18:42:33
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
{ Statement select_stm=conn.createStatement();
result=select_stm.executeQuery(query_statement);}
catch(Exception e)
{System.out.println(e);}
return result;
}
}
______________________________________________
<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
sqltest.setConnection("com.microsoft.jdbc.sqlserver.SQLServerDriver","jdbc:microsoft:sqlserver://localhost:80;DatabaseName=jspdv","sa","sa");
错了://localhost:80这里应该是
://localhost:1433
错误信息?
{sqltest.setConnection("com.microsoft.jdbc.sqlserver.SQLServerDriver","jdbc:microsoft:sqlserver://localhost:80;DatabaseName=jspdv","sa","sa");
sqltest.setQuerystatement(SqlString);
没这个用法吧,你得先打开connection
用connection生成QueryStatement对象
然后执行Query产生ResultSet
SqlServer的默认端口是1433,另外,如果你把sa的密码设了的话密码就没错了。。
不过这sqlbean类写的还真是。。啧啧。
上面的JavaBean错了,给你个正确的实例
package DataBase;
import java.sql.*;
public class MyDbBean {
private Statement stmt = null;
ResultSet rs = null;
private Connection conn = null;
//构造函数
public MyDbBean() {
}
//根据dsn参数,加载驱动程序,建立连接
public void OpenC