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)
{
System.out.println(e);
}
return result;
}
}
登录检查页面代码:
验证页面
您输入的用户名为:
密码为:
我使用的数据库为mysql用户名密码均为root端口是3306端口
org.apache.jasper.JasperException: An exception occurred processing JSP page /check.jsp at line 31
28: try
29:
{
30:
//设置连接
31:
sqltest.setConnection("com.microsoft.jdbc.sqlserver.SQLServerDriver",
32:
"jdbc:microsoft:sqlserver://localhost:3306;DatabaseName=net-hd",
33:
"root","root");
34:
//设置SQL语句
|