package com.javakc.test;
public class Test {
public static void main(String[] args) throws Exception {
boolean f2 =Service.login2("tom","aa");
System.out.println(f2);
}
}
package com.javakc.test;
import com.javakc.db.Utils;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
public class Service {
public static boolean login(String username, String pwd) throws Exception {
boolean flag = false;
Connection conn = Utils.getConn();
Statement stmt = conn.createStatement();
String sql = "select * from t_user where userName='"+username+"'and pwd='" + pwd + "'";
ResultSet rs = stmt.executeQuery(sql);
if (rs.next()) {
flag = true;
}
conn.close();
return flag;
}
public static boolean login2(String username, String pwd) throws Exception {
boolean flag = false;
Connection conn = Utils.getConn();
String sql = "select * from t_user where userName=? and pwd=?";
PreparedStatement stmt=conn. prepareStatement(sql);
stmt.setString(1, username) ;
stmt.setString(2, pwd);
ResultSet rs = stmt.executeQuery();
if (rs.next()) {
flag = true;
}
conn.close();
return flag;
}
}