selectlogin.java

来自「超市管理系统 运行环境JDK1.4以上 JB2006 源代码公开」· Java 代码 · 共 34 行

package com.aptech.classmarket;

import com.aptech.connection.Tosql;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.*;
import java.sql.SQLException;

public class Selectlogin {
    public boolean select(String i,String j){
//        Jdbc jj=new Jdbc();
//        Connection con=jj.jdbcodbc();
       Tosql tt=new Tosql();
       Connection con=tt.tosql();
       boolean flag=false;
       try {
           PreparedStatement ps = con.prepareStatement(
                   "select * from loginmarket where loginid=? and password=?");
           ps.setString(1, i);
           ps.setString(2,j);
           ResultSet rs = ps.executeQuery();
           while (rs.next()) {
               flag = true;
           }
       } catch (SQLException ex) {
       }
       return flag;
   }

    public static void main(String[] args) {

    }
}