login.java

从一开始就使用动态提交技术

package bookshop;
import java.sql.*;
public class login {
	Connection con;
	public login()
	{
		con=bookConnectionSql.getConnect();
	}
	
	public boolean bookexcute(String id1,String password1) throws Exception {
		boolean flag = false;
		Statement stmt=con.createStatement();
		ResultSet rs = stmt.executeQuery("select * from userbook where id = '"+id1+"' and password = '"+password1+"'");
		if (rs.next()){
			
			String	userid = rs.getString(1).trim();
				System.out.println(userid);
				String password=rs.getString(2).trim();
				System.out.println(password);
			flag = true;
		}
		rs.close();
		return flag;		
	}
	public boolean insert(String username,String password)
	{boolean ff=false;
	System.out.print("username"+username+password);
	int number=0;
	try
	  {
	  	java.sql.PreparedStatement pr=con.prepareStatement("insert into userbook(id,password) values(?,?)");
	  	pr.setString(1,username);
	  	pr.setString(2,password);
	  	number =pr.executeUpdate();
	  }catch(Exception e)
	  {
	  	System.out.println(e);
	  }
	  if(number>0)
	  {
	  	try
	  	{
	  		ff=true;
	  	}catch(Exception e)
	  	{
	  		System.out.print(e);
	  	}
	  }
	  return ff;
	}
}