userbean.java

swnglu数据库连接统struts和hinernate

	package model;
	
	import java.sql.PreparedStatement;
	import java.sql.ResultSet;
	import java.util.Vector;
	
	import java.sql.*;
	
	public class UserBean {
		private String username;
		private String password;
	
		public UserBean(String username, String password) {
			this.username = username;
			this.password = password;
	
		}
	
		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 Vector search(String strsql) throws Exception {
			Vector myubs = new Vector();
			Connection conn = DbUtil.connectToDb();
			PreparedStatement pStmt = null;
			ResultSet rs = null;
			pStmt = conn.prepareStatement(strsql);
			
			rs=pStmt.executeQuery();
			while (rs.next()) {
				myubs.add(new UserBean(rs.getString("username"),
						rs.getString("password")));
			}
			rs.close();
			pStmt.close();
			conn.close();
	
			return myubs;
		}
	
		public void insert() throws Exception{
			//周二新加
			Vector myubs = new Vector();
			Connection conn = DbUtil.connectToDb();
			PreparedStatement pStmt=null;
			//周二改PreparedStatement pStmt2=null;
			try{
			conn.setAutoCommit(false);
			//周二改pStmt2 = conn.prepareStatement("update T_user set password='111' where username='teacher'");
			pStmt=conn.prepareStatement("insert into T_user values(?,?)");
			pStmt.setString(1, username);
			pStmt.setString(2, password);
			
			pStmt.executeUpdate();
			//周二pStmt.setString(1,"bahen");
			//周二pStmt.setString(2,"123");
			//周二pStmt.executeUpdate();
			conn.commit();
			}
			catch(Exception e){
				try{
					conn.rollback();
				}
				catch(SQLException ex){
					ex.printStackTrace();	
				}
				throw e;
			}
			pStmt.close();
			conn.close();

		}
	
	
		public boolean login()throws Exception{
		String strsql=null;
		strsql="select * from T_USER where username='"
			+username+"'and password='"+password+"'";
		//新加
		Vector myubs = new Vector();
		  myubs=search(strsql);
		if(myubs.size()>0)
			return true;
			else
				return false;
	
		
		
	}
		/*public static void main(String args[]){
			UserBean myub=new UserBean("teacher" ,"1234");
			try{
				if (myub.login())
				
			System.out.print("success");
			else  System.out.print("false");
			
				}
			catch (Exception e){e.printStackTrace();}
		}*/
}