dbop.java

采用JSP+JavaBean编写的用户登录示例

package Beans;
import java.sql.*;
public class DbOp{
   private Connection conn=null;
   private Statement stmt=null;
   private ResultSet rs=null;
   public DbOp() throws Exception
   {
     try
     {
        Class.forName("com.microsoft.jdbc.sqlsever.SQLServerDriver");
     }
     catch(Exception e)
     {
       throw e;
     }
   }
   public Boolean checkUser(String sUser,String sPwd) throws Exception
   {
      Boolean rtn=false;
      try
      {
          con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=stu;user=sa;passsword=");
          stmt=conn.createStatement();
          rs=stmt.executeQuery("select * from t_user where f_username='"+sUser+"' and f_password='"+sPwd+"'");
          if(rs.next())
             rtn=true;
          else
             rtn=false;
       }
       catch(Exception e)
       {
         throw e;
       }
       finally
       {
          if(rs!=null) rs.close();
          if(stmt!=null) stmt.close();
          if(conn!=null) conn.close();
       }
       retutn rtn;
    }
}