81,094
社区成员
发帖
与我相关
我的任务
分享
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="java.sql.*"%>
<%@ page import="com.DBBean"%>
<jsp:useBean id = "myDBbean" class="com.DBBean"/></jsp useBean>
<%
request.setCharacterEncoding("utf-8");
String uname = request.getParameter("account");
String upwd = request.getParameter("password");
String sql = "select * from user_login where account=? and password=?";
String[] params = new String[2];
params[0] = uname;
params[1] = upwd;
ResultSet rs = myDBbean.excuteQuery(sql,params);
/* Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/RecomSys";
String user = "root";
String password = "zhengchen521";
Connection con = DriverManager.getConnection(url,user,password);
Statement stat = con.createStatement();
ResultSet rs = stat.executeQuery(sql); */
if(rs.next()){
RequestDispatcher rd = request.getRequestDispatcher("welcome_test.jsp");
rd.forward(request,response);
}
else response.sendRedirect("index.jsp");
%>
package com;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DBBean {
private String driver;
private String url;
private String username;
private String password;
private java.sql.Connection con;
private PreparedStatement pstmt;
public String getDriver() {
return driver;
}
public void setDriver(String driver) {
this.driver = driver;
}
public String getUrl() {
return url;
}
public void setUrl(String url) {
this.url = url;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public DBBean(){
driver="com.mysql.jdbc.Driver";
url="jdbc:mysql://localhost:3306/RecomSys";
username="root";
password="zhengchen521";
//init();
}
private void init(){
try{
Class.forName(driver);
con= DriverManager.getConnection(url,username,password);
}
catch(ClassNotFoundException e){
e.printStackTrace();
}catch (SQLException e){
e.printStackTrace();
}
}
public void close()
{
try{
if(con!=null)
con.close();
}catch(Exception e){
e.printStackTrace();
}
try{
if(pstmt!=null)
pstmt.close();
}catch(Exception e){
e.printStackTrace();
}
}
private void setParams(String sql,String[] params){
if(params!= null){
for(int i=0;i<params.length;i++){
try{
pstmt.setString(i+1,params[i]);
}catch(SQLException e){
e.printStackTrace();
}
}
}
}
public ResultSet excuteQuery(String sql,String[]params){
ResultSet rs=null;
init();
try{
pstmt=con.prepareStatement(sql);
setParams(sql,params);
rs=pstmt.executeQuery();
}catch(SQLException e){
e.printStackTrace();
}
return rs;
}
public int executeUpdate(String sql,String[]params){
int result =0;
init();
try{ pstmt=con.prepareStatement(sql);
setParams(sql,params);
result=pstmt.executeUpdate();
}catch(SQLException e){
e.printStackTrace();
}
return result;
}
}
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="java.sql.*"%>
<%@ page import="com.DBBean"%>
<%
request.setCharacterEncoding("utf-8");
String uname = request.getParameter("account");
String upwd = request.getParameter("password");
String sql = "select * from user_login where account=? and password=?";
String[] params = new String[2];
params[0] = uname;
params[1] = upwd;
DBBean db = new DBBean();
ResultSet rs = db.query(sql,params);
/* Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/RecomSys";
String user = "root";
String password = "zhengchen521";
Connection con = DriverManager.getConnection(url,user,password);
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setString(1,params[0]);
pstmt.setString(2,params[1]);
ResultSet rs = pstmt.executeQuery(); */
if(rs.next()){
RequestDispatcher rd = request.getRequestDispatcher("welcome_test.jsp");
rd.forward(request,response);
}
else response.sendRedirect("index.jsp");
%>
是这样了_(:з」∠)_[/quote]
额。。。我没出现过这种问题。。
你试一下这个http://blog.csdn.net/advance1989/article/details/6673730<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="java.sql.*"%>
<%@ page import="com.DBBean"%>
<%
request.setCharacterEncoding("utf-8");
String uname = request.getParameter("account");
String upwd = request.getParameter("password");
String sql = "select * from user_login where account=? and password=?";
String[] params = new String[2];
params[0] = uname;
params[1] = upwd;
DBBean db = new DBBean();
ResultSet rs = db.query(sql,params);
/* Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/RecomSys";
String user = "root";
String password = "zhengchen521";
Connection con = DriverManager.getConnection(url,user,password);
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setString(1,params[0]);
pstmt.setString(2,params[1]);
ResultSet rs = pstmt.executeQuery(); */
if(rs.next()){
RequestDispatcher rd = request.getRequestDispatcher("welcome_test.jsp");
rd.forward(request,response);
}
else response.sendRedirect("index.jsp");
%>