package com.jie.java.phone;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
public class login {
public static HttpSession session=null;
public static final String username="abin";
public static final String password="abing";
public static void main(String args[]){
boolean result=checkuser(username,password,session);
System.out.println(result+":-------:数据库验证成功");
}
public static Connection getConn(){
Connection conn=null;
try{
Class.forName("com.ibm.db2.jcc.DB2Driver");
String url="jdbc:db2://localhost:50000/connect";
conn=DriverManager.getConnection(url,"acer","abin");
}catch(Exception e){
e.printStackTrace();
System.out.println("数据库连接失败");
}
return conn;
}
public static boolean checkuser(String username,String password,HttpSession session){
boolean result=false;
try{
String sql="select * from connect where username='"+username+"' and password='"+password+"'";
ResultSet rs=login.getConn().createStatement().executeQuery(sql);
if(rs.next()){
result=true;
// System.out.println("dfsaf");
// session.setAttribute("username", rs.getString("username"));
}
}catch(Exception e){
e.printStackTrace();
}
return result;
}
}
http://zhidao.baidu.com/question/178808868.html