?? dusers.java
字號:
package com.gc.dao;
import com.gc.action.Users;
import com.gc.impl.IUsers;
import java.sql.*;
public class DUsers implements IUsers{
private Connection con = null;
private PreparedStatement pre = null;
private ResultSet rs = null;
public boolean isUsers(String account,String password)
{
boolean user = false;
try
{
dao d = new dao();
this.con = d.getCon();
if(con != null)
{
pre = con.prepareStatement("select * from Users where UAccount='"+account+"' and UPassword='"+password+"'");
rs = pre.executeQuery();
while(rs.next())
{
user = true;
}
}
rs.close();
pre.close();
con.close();
}catch(Exception ex)
{
ex.printStackTrace();
}
return user;
}
/**
* 添加用戶信息
*/
public boolean addUsers(Users users) {
int count = 0;
try
{
dao d = new dao();
con = d.getCon();
if(con!=null)
{
pre = con.prepareStatement("insert into Users(UAccount,UPassword,UName) values(?,?,?)");
pre.setString(1, users.getAccount());
pre.setString(2, users.getUpassword());
pre.setString(3, users.getUname());
count = pre.executeUpdate();
}
pre.close();
con.close();
con.close();
}catch(Exception e)
{
e.printStackTrace();
}
if(count>0)
{
}else
{
return false;
}
}
public boolean isExistUsers(String account) {
boolean user = false;
try
{
dao d = new dao();
this.con = d.getCon();
if(con != null)
{
pre = con.prepareStatement("select * from Users where UAccount='"+account+"'");
rs = pre.executeQuery();
while(rs.next())
{
user = true;
}
}
rs.close();
pre.close();
con.close();
}catch(Exception ex)
{
ex.printStackTrace();
}
return user;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -