[Java] 纯文本查看 复制代码package day1;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Scanner;
public class LoginSample2 {
public static void main(String[] args) {
Scanner sc = new Scanner(System.in);
System.out.println("请输入卡号");
int cardId = sc.nextInt();
System.out.println("请输入密码");
String password = sc.next();
//jdbc的六个步骤验证卡号和密码是否正确
Connection conn = null;
PreparedStatement pstm = null;
ResultSet rs = null;
try{
Class.forName("oracle.jdbc.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:XE","hr","hr");
String sql = "select * from account where cardid=? and password=? ";
pstm = conn.prepareStatement(sql);
//为?设置值
pstm.setInt(1, cardId);
pstm.setString(2, password);
rs = pstm.executeQuery();
if(rs.next()){
System.out.println("恭喜你,登录成功");
}else{
System.out.println("对不起,登录失败");
}
}catch (Exception e) {
e.printStackTrace();
} finally{
if(rs!=null) try{ rs.close(); }catch(Exception e){}
if(pstm!=null) try{ pstm.close(); }catch(Exception e){}
if(conn!=null) try{ conn.close(); }catch(Exception e){}
}
}
}