f00a39e80d7e001d142cd413af2866bc

Servlet 、Jsp 、数据库结合

package mypack;

import java.sql.*;

public class SQLQuery {   //处理业务逻辑的JavaBean
	public  static boolean validate(String username,String password){//验证用户密码是否正确
		boolean bool=false;
		try {
			Class.forName("com.mysql.jdbc.Driver");  //加载数据库驱动
			//建立与数据库连接,在数据库中检查是否存在用户名为：username，对应密码为password的用户
			Connection conn=DriverManager.getConnection("jdbc:mysql://192.168.1.224:3306/test","root","root");
			//创建Statement对象
			Statement stmt=(Statement)conn.createStatement();
			//使用SQL语句操作数据库
			ResultSet rs=(ResultSet)stmt.executeQuery("select*from userinfo where username='"+username+"'and password='"+password+"'");
			if(rs.next()) bool=true;
			else bool=false;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return bool;
	}
	
	public static Userinfo userinfoQuery(String username){//返回用户信息
		Userinfo ui=new Userinfo();//创建Userinfo对象，来保存从数据库中获取 的用户信息
		try {
			Class.forName("com.mysql.jdbc.Driver");
			Connection conn=DriverManager.getConnection("jdbc:mysql://192.168.1.224:3306/test","root","root");
			Statement stmt=(Statement)conn.createStatement();
			ResultSet rs=(ResultSet)stmt.executeQuery("select*from userinfo where username='"+username+"'");
			while(rs.next()){
				ui.setName(rs.getString(2));
				ui.setAge(rs.getInt(4));
				ui.setGender(rs.getString(5));
				ui.setEmail(rs.getString(6));
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		
		return ui;
				
	}

}