?? usermanger.java
字號:
package com.yourcompany.struts;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.List;
import java.util.LinkedList;
public class UserManger {
private Connection con=null;
private Statement st = null;
private ResultSet rs=null;
private boolean bool;
String userName;
public UserManger()
{
try{
Class.forName("org.gjt.mm.mysql.Driver");
con=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/" +
"mydb","root","admin");
}catch(Exception se){
se.printStackTrace();
}
}
public List list() {
Person temp;
List<Person> list=new LinkedList();
System.out.println("11");
try{
st=con.createStatement();
rs=st.executeQuery("SELECT * FROM user");
while(rs.next())
{
temp=new Person();
System.out.println(rs.getString(1));
temp.setName(rs.getString(1));
System.out.println(temp.getName());
temp.setPassword(rs.getString(2));
temp.setState(rs.getString(3));
list.add(temp);
}
st.close();
rs.close();
}
catch(SQLException sql){sql.printStackTrace();}
return list;
}
public boolean checkUser(String userName,String password)
{
String user;
String word;
user=userName;
word=password;
try{
st=con.createStatement();
rs=st.executeQuery("SELECT * FROM user WHERE username=\'"+user+"\' and " +
"userpwd=\'"+word+"\'");
if(rs.next())
{
bool=true;
}else
bool=false;
st.close();
rs.close();
}catch(SQLException sql){sql.printStackTrace();}
return bool;
}
public void addUser(String userName,String password)
{
String user;
String word;
user=userName;
word=password;
try{
st=con.createStatement();
st.execute("INSERT INTO user(username,userpwd,roke)VALUES('"+user+"','"+word+"','1')");
st.close();
}catch(SQLException sql){sql.printStackTrace();}
}
public void delUser(String userName){
String user;
user=userName;
try{
st=con.createStatement();
st.execute("DELETE from user where username='"+user+"'");
st.close();
}catch(SQLException sql)
{sql.printStackTrace();}
}
public void updateUser(String userName,String password,String roke){
String user,npwd,nroke;
user=userName;
npwd=password;
nroke=roke;
try{
st=con.createStatement();
st.execute("update user set userpwd = '"+npwd+"',roke='"+nroke+"' where username = '"+user+"'");
}catch(SQLException sql)
{sql.printStackTrace();}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -