?? userserver.java
字號:
package serives;
import java.sql.*;
import beans.UserBean;
import DbUtil.DbLink;
import java.util.ArrayList;
import beans.BookInfoBean;
import beans.BuyBookInfo;
public class userserver {
private static String sql1 = "SELECT * FROM UserInfo WHERE UserName=?";
private static String sql2 = "SELECT * FROM UserInfo WHERE PassWord=?";
private static String sql3 = "SELECT num,name,rmb FROM BookInfo";
private static String sql4 =
"INSERT INTO UserInfo(UserName,PassWord,Sex,Tel,Address) VALUES(?,?,?,?,?)";
private static String sql5 =
"INSERT INTO BuyBookInfo(username,buybook,sumrmb,buydate) VALUES(?,?,?,?)";
public static boolean isSelectUser(UserBean bean) {
boolean flag = false;
try {
Connection con = DbLink.getConnection();
PreparedStatement prs = con.prepareStatement(sql1);
prs.setString(1, bean.getUsername());
ResultSet rs = prs.executeQuery();
if (rs.next()) {
flag = true;
} else {
flag = false;
}
rs.close();
prs.close();
con.close();
} catch (Exception ex) {
ex.printStackTrace();
}
return flag;
}
public static boolean isSelectPassWord(UserBean bean) {
boolean flag = false;
try {
Connection con = DbLink.getConnection();
PreparedStatement prs = con.prepareStatement(sql2);
prs.setString(1, bean.getUserpassword());
ResultSet rs = prs.executeQuery();
if (rs.next()) {
flag = true;
} else {
flag = false;
}
rs.close();
prs.close();
con.close();
} catch (Exception ex) {
ex.printStackTrace();
}
return flag;
}
public static ArrayList SelectBookInfo() {
ArrayList list = new ArrayList();
try {
Connection con = DbLink.getConnection();
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sql3);
while (rs.next()) {
BookInfoBean bookbean = new BookInfoBean();
bookbean.setNum(rs.getString(1));
bookbean.setName(rs.getString(2));
bookbean.setRmb(rs.getString(3));
list.add(bookbean);
}
rs.close();
st.close();
con.close();
} catch (Exception ex) {
ex.printStackTrace();
}
return list;
}
public static void insertUserInfo(UserBean bean) {
try {
Connection con = DbLink.getConnection();
PreparedStatement prs = con.prepareStatement(sql4);
prs.setString(1, bean.getUsername());
prs.setString(2, bean.getUserpassword());
prs.setString(3, bean.getSex());
prs.setString(4, bean.getTel());
prs.setString(5, bean.getAddress());
prs.executeUpdate();
prs.close();
con.close();
} catch (Exception ex) {
ex.printStackTrace();
}
}
public static void insertBuyBookInfo(BuyBookInfo buybean) {
try {
Connection con = DbLink.getConnection();
PreparedStatement prs = con.prepareStatement(sql5);
prs.setString(1, buybean.getUsername());
prs.setString(2, buybean.getBuybook());
prs.setString(3, buybean.getSumrmb());
prs.setString(4, buybean.getBuydate());
prs.executeUpdate();
prs.close();
con.close();
} catch (Exception ex) {
ex.printStackTrace();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -