databaseoptor.java~7~

一个JSPServerlet编写的

package regetemail;

import java.sql.Connection;
import java.sql.SQLException;

public class DataBaseOptor {
    private Connection conn;
    public DataBaseOptor() {

    }

    private Connection getConn() {
        boolean flag = false;
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch (ClassNotFoundException ex) {
            System.out.println("建立驱动异常：" + ex.getMessage());
        }
        try {
            conn = java.sql.DriverManager.getConnection("jdbc:odbc:accp", "sa",
                    "");
        } catch (SQLException ex) {
            System.out.println("数据库连接异常");
        }
        return conn;
    }

    public boolean getUser(String uname, String upwd) {
        boolean flag = false;
        try {
            Connection con = this.getConn();
            java.sql.Statement stm = con.createStatement();
            java.sql.ResultSet rs = stm.executeQuery(
                    "select * from userInfo where userName='"+uname+"' and userPassword='"+upwd+"'");
            if(rs.next()){
                flag = true;
            }
        } catch (SQLException ex) {
            System.out.println("验证用户密码异常：" + ex.getMessage());
        }
        return flag;
    }

}