?? e0b4bdad747e001d164defa693ec78e5
字號(hào):
package mypack;
import java.sql.*;
public class SQLQuery { //處理業(yè)務(wù)邏輯的JavaBean
public static boolean validate(String username,String password){//驗(yàn)證用戶密碼是否正確
boolean bool=false;
try {
Class.forName("com.mysql.jdbc.Driver"); //加載數(shù)據(jù)庫(kù)驅(qū)動(dòng)
//建立與數(shù)據(jù)庫(kù)連接,在數(shù)據(jù)庫(kù)中檢查是否存在用戶名為:username,對(duì)應(yīng)密碼為password的用戶
Connection conn=DriverManager.getConnection("jdbc:mysql://192.168.1.224:3306/test","root","root");
//創(chuàng)建Statement對(duì)象
Statement stmt=(Statement)conn.createStatement();
//使用SQL語(yǔ)句操作數(shù)據(jù)庫(kù)
ResultSet rs=(ResultSet)stmt.executeQuery("select*from userinfo where username='"+username+"'and password='"+password+"'");
if(rs.next()) bool=true;
else bool=false;
} catch (Exception e) {
e.printStackTrace();
}
return bool;
}
public static Userinfo userinfoQuery(String username){//返回用戶信息
Userinfo ui=new Userinfo();//創(chuàng)建Userinfo對(duì)象,來(lái)保存從數(shù)據(jù)庫(kù)中獲取 的用戶信息
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://192.168.1.224:3306/test","root","root");
Statement stmt=(Statement)conn.createStatement();
ResultSet rs=(ResultSet)stmt.executeQuery("select*from userinfo where username='"+username+"'");
while(rs.next()){
ui.setName(rs.getString(2));
ui.setAge(rs.getInt(4));
ui.setGender(rs.getString(5));
ui.setEmail(rs.getString(6));
}
} catch (Exception e) {
e.printStackTrace();
}
return ui;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -