lian.java~4~

来自「修改密码的」· JAVA~4~ 代码 · 共 65 行

package accp.gq.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import java.sql.*;

/**
 * <p>Title: 修改密码</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author 郭庆
 * @version 1.0
 */
public class Lian {
    public Lian() {
        super();
    }

    public Connection getcon() {
        Connection con = null;
        try {
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        }
        try {
            con = DriverManager.getConnection(
                    "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=test","sa","");
        } catch (SQLException ex1) {
            ex1.printStackTrace();
        }
        return con;

    }
    public boolean select(Frame1 frm){
        Connection con=this.getcon();
        PreparedStatement pre=null;
        ResultSet res=null;
      String a=  frm.txtid.getText();
       String b=   frm.txtoldpassword.getText();
        String sql="select * UserInfo where LoginName=? and PassWord=?";
        try {
            pre = con.prepareStatement(sql);
            pre.setString(1,a);
             pre.setString(2,b);
             res=pre.executeQuery();
             if(res.next()){
                 return true;
             }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }finally{
            res.close();
        }
        return false;

    }
}