package qyxx;
import java.sql.*;
public class userDB
{
String DBDriver = "oracle.jdbc.driver.OracleDriver";
String DBUrl = "jdbc:oracle:thin:@localhost:1521:ORACLE";
String DBUser = "jerry";
String DBPsw = "123456";
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
private Connection initDB()
{
try
{
Class.forName(DBDriver);
return DriverManager.getConnection(DBUrl,DBUser,DBPsw);
}
catch (Exception e)
{
e.printStackTrace();
return null;
}
}
public userTable loginCheck(String username, String password)
{
try
{
this.conn = null;
conn = this.initDB();
String sql = "select DISTINCT priority,name,age,sex, depart_name, depart_id from QYXX_USER a, QYXX_DEPARTMENT b where a.username='"+username+"' and a.password = '"+password+"' and b.id = a.depart_id";
this.stmt = null;
this.rs = null;
this.stmt = conn.prepareStatement(sql);
rs = this.stmt.executeQuery();
if(rs.next())
{
userTable ut = new userTable();
ut.setUsername(username);
ut.setPriority(rs.getString(1));
ut.setName(rs.getString(2));
ut.setAge(rs.getString(3));
ut.setSex(rs.getString(4));
ut.setDepartname(rs.getString(5));
ut.setDepartid(String.valueOf(rs.getInt(6)));
return ut;
}
else
{
return null;
}
}
catch (Exception e)
{
e.printStackTrace();
return null;
}
finally
{
try
{
conn.close();
stmt.close();
rs.close();
}
catch(Exception e)
{
}
}
}
public userTable getUserInfo(String username)
{
try
{
String sql = "select * from QYXX_USER where username = '"+username+"'";
this.conn = null;
conn = this.initDB();
this.stmt = null;
this.stmt = conn.prepareStatement(sql);
rs = this.stmt.executeQuery();
if(rs.next())
{
userTable ut = new userTable();
ut.setUsername(rs.getString("username"));
ut.setPassword(rs.getString("password"));
ut.setName(rs.getString("name"));
ut.setAge(rs.getString("age"));
ut.setSex(rs.getString("sex"));
ut.setDepartid(String.valueOf(rs.getInt("depart_id")));
return ut;
}
else
{
return null;
}
}
catch (Exception e)
{
e.printStackTrace();
return null;
}
finally
{
try
{
conn.close();
stmt.close();
rs.close();
}
catch(Exception e)
{
}
}
}
public int addUser(qyxx.userTable utable)
{
try
{
this.conn = null;
conn = this.initDB();
String sql = "insert into QYXX_USER(username,password,priority,name,age,sex,depart_id) values(?,?,?,?,?,?,?)";
this.stmt = null;
this.stmt = conn.prepareStatement(sql);
stmt.setString(1,utable.getUsername());
stmt.setString(2,utable.getPassword());
stmt.setString(3,utable.getPriority());
stmt.setString(4,utable.getName());
stmt.setString(5,utable.getAge());
stmt.setString(6,utable.getSex());
stmt.setString(7,utable.getDepartid());
this.stmt.executeUpdate();
return 1;
}
catch (Exception e)
{
e.printStackTrace();
return 0;
}
finally
{
try
{
conn.close();
stmt.close();
}
catch(Exception e)
{
}
}
}
public qyxx.userTable editUser(qyxx.userTable utable)
{
try
{
this.conn = null;
conn = this.initDB();
String sql = "update QYXX_USER set password = ?, name=?, age=?, sex=?, depart_id=? where username=?";
this.stmt = null;
this.rs = null;
this.stmt = conn.prepareStatement(sql);
stmt.setString(1,utable.getPassword());
stmt.setString(2,utable.getName());
stmt.setString(3,utable.getAge());
stmt.setString(4,utable.getSex());
stmt.setString(5,utable.getDepartid());
stmt.setString(6,utable.getUsername());
stmt.executeUpdate();
sql = "select DISTINCT name,age,sex,depart_name,depart_id from QYXX_USER a,QYXX_DEPARTMENT b where a.username=? and b.id = a.depart_id";
this.stmt = null;
this.stmt = conn.prepareStatement(sql);
stmt.setString(1,utable.getUsername());
rs = this.stmt.executeQuery();
if(rs.next())
{
utable.setName(rs.getString(1));
utable.setAge(rs.getString(2));
utable.setSex(rs.getString(3));
utable.setDepartname(rs.getString(4));
utable.setDepartid(String.valueOf(rs.getInt(5)));
return utable;
}
else
{
return null;
}
}
catch (Exception e)
{
e.printStackTrace();
return null;
}
finally
{
try
{
conn.close();
stmt.close();
rs.close();
}
catch(Exception e)
{
}
}
}
public int deleteUser(String [] username)
{
try
{
this.conn = null;
conn = this.initDB();
for(int i=0; i<username.length; i++)
{
String sql = "delete from QYXX_USER where username = '"+username[i]+"'";
this.stmt = null;
this.stmt = conn.prepareStatement(sql);
this.stmt.executeUpdate();
}
return 1;
}
catch (Exception e)
{
e.printStackTrace();
return 0;
}
finally
{
try
{
conn.close();
stmt.close();
}
catch(Exception e)
{
}
}
}
public int editUserPriority(String [] username,int choice)
{
try
{
if(choice == 1)
{
this.conn = null;
conn = this.initDB();
for(int i=0; i<username.length; i++)
{
String sql = "update QYXX_USER set priority='2' where username = '"+username[i]+"'";
this.stmt = null;
this.stmt = conn.prepareStatement(sql);
this.stmt.executeUpdate();
}
}
else
{
if(choice == 2)
{
this.conn = null;
conn = this.initDB();
for(int i=0; i<username.length; i++)
{
String sql = "update QYXX_USER set priority='1' where username = '"+username[i]+"'";
this.stmt = null;
this.stmt = conn.prepareStatement(sql);
this.stmt.executeUpdate();
}
}
else
{
rs = null;
conn = this.initDB();
for(int i=0; i<username.length; i++)
{
String sql = "select priority from QYXX_USER where username = '"+username[i]+"'";
this.stmt = null;
this.stmt = conn.prepareStatement(sql);
rs = this.stmt.executeQuery();
if(rs.next())
{
String pr = rs.getString(1);
int p = Integer.parseInt(pr) + 1;
sql = "update QYXX_USER set priority = '"+String.valueOf(p)+"' where username = '"+username[i]+"'";
this.stmt = null;
this.stmt = conn.prepareStatement(sql);
stmt.executeUpdate();
}
else
{
return 0;
}
}
}
}
return 1;
}
catch (Exception e)
{
e.printStackTrace();
return 0;
}
finally
{
try
{
conn.close();
stmt.close();
}
catch(Exception e)
{
}
}
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
企业管理系统(JSP)
共74个文件
jsp:52个
class:9个
java:9个
需积分: 9 30 下载量 151 浏览量
2008-10-17
13:19:38
上传
评论
收藏 75KB RAR 举报
温馨提示
企业管理系统是用JSP编写的。使用了MVC模式。实现了该系统的基本功能,里面有SQL语句,经过简单配置,就可以运行,适合参考学习。
资源推荐
资源详情
资源评论
收起资源包目录
.rar (74个子文件)
企业窡理-第十一秠示事程嶏
数据嶓
qyxx_table.sql 8KB
css
style.css 3KB
user_delete.jsp 709B
user_deal.jsp 4KB
main_index.jsp 0B
WEB-INF
web.xml 382B
classes
qyxx
connectDB.class 2KB
produceDB.class 4KB
moneyDB.class 5KB
userTable.class 1KB
moneyTable.class 1KB
salesTable.class 2KB
userDB.class 6KB
produceTable.class 1KB
salesDB.class 5KB
salesDB.java 6KB
produceTable.java 1KB
userTable.java 1KB
produceDB.java 4KB
moneyTable.java 1KB
moneyDB.java 4KB
salesTable.java 2KB
userDB.java 7KB
connectDB.java 1KB
user_list_z.jsp 3KB
user_add.jsp 3KB
user_degrade.jsp 720B
top_index.jsp 2KB
user_list_j.jsp 3KB
error.jsp 672B
user_list_p.jsp 2KB
produce
produce_list_j.jsp 2KB
produce_delete_p.jsp 2KB
produce_update_z.jsp 2KB
produce_add.jsp 2KB
produce_update_j.jsp 2KB
produce_delete_j.jsp 2KB
produce_deal.jsp 2KB
produce_update_p.jsp 2KB
produce_detail.jsp 4KB
produce_list_p.jsp 2KB
produce_delete_z.jsp 2KB
produce_list_z.jsp 2KB
money
money_update_p.jsp 2KB
money_list_j.jsp 2KB
money_delete_z.jsp 2KB
money_deal.jsp 2KB
money_add.jsp 1KB
money_delete_j.jsp 2KB
money_update_z.jsp 2KB
money_detail.jsp 4KB
money_delete_p.jsp 2KB
money_list_z.jsp 2KB
error.jsp 798B
money_list_p.jsp 2KB
money_update_j.jsp 2KB
user_upgrade.jsp 1KB
user_update.jsp 4KB
sales
sales_delete_p.jsp 2KB
sales_list_z.jsp 2KB
sales_delete_z.jsp 2KB
sales_list_p.jsp 2KB
sales_update_p.jsp 2KB
sales_update_j.jsp 2KB
sales_list_j.jsp 2KB
sales_delete_j.jsp 2KB
sales_update_z.jsp 2KB
sales_deal.jsp 2KB
sales_detail.jsp 4KB
sales_add.jsp 2KB
user_list.jsp 2KB
index.html 893B
logout.jsp 391B
left_index.jsp 7KB
共 74 条
- 1
资源评论
zjw6666zjw
- 粉丝: 6
- 资源: 46
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功