查查
来源:互联网 发布:linux top 查看子进程 编辑:程序博客网 时间:2024/04/26 08:45
public class UnisDao {
public void insertUser(UnisVo unisVo)
{
Statement st = null;
Connection conn = null;
try {
//Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //加载驱动
//conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=unisdb","sa","sa"); //
conn = DbManage.getConnection();
st = conn.createStatement(); //发送指令集
String sql = "INSERT INTO tableunis (user_name,user_password,user_surepassword,user_sex,user_birth,user_hobby,user_native,user_introduce) VALUES ('"+unisVo.getUserName()+"','"+unisVo.getInputPassword()+"','"+unisVo.getSurePassword()+"','"+unisVo.getUserSex()+"','"+unisVo.getUserYear()+"年"+unisVo.getUserMonth()+"月"+unisVo.getUserDay()+"日"+"','"+unisVo.getUserEnioy()+"','"+unisVo.getProvinceInfo()+unisVo.getCityInfo()+"','"+unisVo.getUserIntroduce()+"')";
//System.out.println(sql);
st.executeUpdate(sql); // 无返回值
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
DbManage.closeDB(st, conn);
}
}
public ArrayList selectUser()
{
Statement st = null;
Connection conn = null;
ResultSet rs = null;
ArrayList unisList = new ArrayList();
try {
//Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //加载驱动
//conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=unisdb","sa","sa"); //
conn = DbManage.getConnection();
st = conn.createStatement(); //发送指令集
String sql = "SELECT * FROM tableunis WHERE user_display = 1";
rs = st.executeQuery(sql);
while(rs.next())
{
UnisVo unisVo = new UnisVo();
unisVo.setUserID(rs.getInt("user_id"));
unisVo.setUserName(rs.getString("user_name"));
unisVo.setInputPassword(rs.getString("user_password"));
unisVo.setSurePassword(rs.getString("user_surepassword"));
unisVo.setUserSex(rs.getString("user_sex"));
unisVo.setUserYear(rs.getString("user_birth"));
unisVo.setUserMonth(rs.getString("user_birth"));
unisVo.setUserDay(rs.getString("user_birth"));
unisVo.setUserEnioy(rs.getString("user_hobby"));
unisVo.setProvinceInfo(rs.getString("user_native"));
unisVo.setCityInfo(rs.getString("user_native"));
unisVo.setUserIntroduce(rs.getString("user_introduce"));
unisList.add(unisVo);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
DbManage.closeDB(rs, st, conn);
}
return unisList;
}
public void deleteUser(String userID)
{
Statement st = null;
Connection conn = null;
try {
//Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //加载驱动
//conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=unisdb","sa","sa"); //
conn = DbManage.getConnection();
st = conn.createStatement(); //发送指令集
String sql = "UPDATE tableunis SET user_display = 0 WHERE user_id = '"+userID+"'";
//System.out.println(sql);
st.executeUpdate(sql); // 无返回值
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
DbManage.closeDB(st, conn);
}
}
public UnisVo selectOneUser(String userID)
{
Statement st = null;
Connection conn = null;
ResultSet rs = null;
UnisVo unisVo = new UnisVo();
try {
//Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //加载驱动
//conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=unisdb","sa","sa"); //
conn = DbManage.getConnection();
st = conn.createStatement(); //发送指令集
String sql = "SELECT * FROM tableunis WHERE user_display = 1 AND user_id = '"+userID+"'";
rs = st.executeQuery(sql);
while(rs.next())
{
unisVo.setUserID(rs.getInt("user_id"));
unisVo.setUserName(rs.getString("user_name"));
unisVo.setInputPassword(rs.getString("user_password"));
unisVo.setSurePassword(rs.getString("user_surepassword"));
unisVo.setUserSex(rs.getString("user_sex"));
unisVo.setUserYear(rs.getString("user_birth"));
unisVo.setUserMonth(rs.getString("user_birth"));
unisVo.setUserDay(rs.getString("user_birth"));
unisVo.setUserEnioy(rs.getString("user_hobby"));
unisVo.setProvinceInfo(rs.getString("user_native"));
unisVo.setCityInfo(rs.getString("user_native"));
unisVo.setUserIntroduce(rs.getString("user_introduce"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
DbManage.closeDB(rs, st, conn);
}
return unisVo;
}
public void deleteUsers(String[] deleteUserIds)
{
Statement st = null;
Connection conn = null;
try {
//Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //加载驱动
//conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=unisdb","sa","sa"); //
conn = DbManage.getConnection();
st = conn.createStatement(); //发送指令集
for(int i=0;i<deleteUserIds.length;i++)
{
String sql = "UPDATE tableunis SET user_display = 0 WHERE user_id = '"+deleteUserIds[i]+"'";
//System.out.println(sql);
st.executeUpdate(sql); // 无返回值
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
DbManage.closeDB(st, conn);
}
}
public void updateUser(UnisVo unisVo)
{
Statement st = null;
Connection conn = null;
try {
//Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //加载驱动
//conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=unisdb","sa","sa"); //
conn = DbManage.getConnection();
st = conn.createStatement(); //发送指令集
String sql = "UPDATE tableunis SET user_name = '"+unisVo.getUserName()+"',user_password = '"+unisVo.getInputPassword()+"',user_surepassword = '"+unisVo.getSurePassword()+"',user_sex = '"+unisVo.getUserSex()+"',user_birth='"+unisVo.getUserYear()+"年"+unisVo.getUserMonth()+"月"+unisVo.getUserDay()+"日"+"',user_hobby = '"+unisVo.getUserEnioy()+"',user_native = '"+unisVo.getProvinceInfo()+unisVo.getCityInfo()+"',user_introduce = '"+unisVo.getUserIntroduce()+"' WHERE user_id = '"+unisVo.getUserID()+"'";
//System.out.println(sql);
st.executeUpdate(sql); // 无返回值
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
DbManage.closeDB(st, conn);
}
}
public void insertUser(UnisVo unisVo)
{
Statement st = null;
Connection conn = null;
try {
//Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //加载驱动
//conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=unisdb","sa","sa"); //
conn = DbManage.getConnection();
st = conn.createStatement(); //发送指令集
String sql = "INSERT INTO tableunis (user_name,user_password,user_surepassword,user_sex,user_birth,user_hobby,user_native,user_introduce) VALUES ('"+unisVo.getUserName()+"','"+unisVo.getInputPassword()+"','"+unisVo.getSurePassword()+"','"+unisVo.getUserSex()+"','"+unisVo.getUserYear()+"年"+unisVo.getUserMonth()+"月"+unisVo.getUserDay()+"日"+"','"+unisVo.getUserEnioy()+"','"+unisVo.getProvinceInfo()+unisVo.getCityInfo()+"','"+unisVo.getUserIntroduce()+"')";
//System.out.println(sql);
st.executeUpdate(sql); // 无返回值
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
DbManage.closeDB(st, conn);
}
}
public ArrayList selectUser()
{
Statement st = null;
Connection conn = null;
ResultSet rs = null;
ArrayList unisList = new ArrayList();
try {
//Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //加载驱动
//conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=unisdb","sa","sa"); //
conn = DbManage.getConnection();
st = conn.createStatement(); //发送指令集
String sql = "SELECT * FROM tableunis WHERE user_display = 1";
rs = st.executeQuery(sql);
while(rs.next())
{
UnisVo unisVo = new UnisVo();
unisVo.setUserID(rs.getInt("user_id"));
unisVo.setUserName(rs.getString("user_name"));
unisVo.setInputPassword(rs.getString("user_password"));
unisVo.setSurePassword(rs.getString("user_surepassword"));
unisVo.setUserSex(rs.getString("user_sex"));
unisVo.setUserYear(rs.getString("user_birth"));
unisVo.setUserMonth(rs.getString("user_birth"));
unisVo.setUserDay(rs.getString("user_birth"));
unisVo.setUserEnioy(rs.getString("user_hobby"));
unisVo.setProvinceInfo(rs.getString("user_native"));
unisVo.setCityInfo(rs.getString("user_native"));
unisVo.setUserIntroduce(rs.getString("user_introduce"));
unisList.add(unisVo);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
DbManage.closeDB(rs, st, conn);
}
return unisList;
}
public void deleteUser(String userID)
{
Statement st = null;
Connection conn = null;
try {
//Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //加载驱动
//conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=unisdb","sa","sa"); //
conn = DbManage.getConnection();
st = conn.createStatement(); //发送指令集
String sql = "UPDATE tableunis SET user_display = 0 WHERE user_id = '"+userID+"'";
//System.out.println(sql);
st.executeUpdate(sql); // 无返回值
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
DbManage.closeDB(st, conn);
}
}
public UnisVo selectOneUser(String userID)
{
Statement st = null;
Connection conn = null;
ResultSet rs = null;
UnisVo unisVo = new UnisVo();
try {
//Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //加载驱动
//conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=unisdb","sa","sa"); //
conn = DbManage.getConnection();
st = conn.createStatement(); //发送指令集
String sql = "SELECT * FROM tableunis WHERE user_display = 1 AND user_id = '"+userID+"'";
rs = st.executeQuery(sql);
while(rs.next())
{
unisVo.setUserID(rs.getInt("user_id"));
unisVo.setUserName(rs.getString("user_name"));
unisVo.setInputPassword(rs.getString("user_password"));
unisVo.setSurePassword(rs.getString("user_surepassword"));
unisVo.setUserSex(rs.getString("user_sex"));
unisVo.setUserYear(rs.getString("user_birth"));
unisVo.setUserMonth(rs.getString("user_birth"));
unisVo.setUserDay(rs.getString("user_birth"));
unisVo.setUserEnioy(rs.getString("user_hobby"));
unisVo.setProvinceInfo(rs.getString("user_native"));
unisVo.setCityInfo(rs.getString("user_native"));
unisVo.setUserIntroduce(rs.getString("user_introduce"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
DbManage.closeDB(rs, st, conn);
}
return unisVo;
}
public void deleteUsers(String[] deleteUserIds)
{
Statement st = null;
Connection conn = null;
try {
//Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //加载驱动
//conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=unisdb","sa","sa"); //
conn = DbManage.getConnection();
st = conn.createStatement(); //发送指令集
for(int i=0;i<deleteUserIds.length;i++)
{
String sql = "UPDATE tableunis SET user_display = 0 WHERE user_id = '"+deleteUserIds[i]+"'";
//System.out.println(sql);
st.executeUpdate(sql); // 无返回值
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
DbManage.closeDB(st, conn);
}
}
public void updateUser(UnisVo unisVo)
{
Statement st = null;
Connection conn = null;
try {
//Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //加载驱动
//conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=unisdb","sa","sa"); //
conn = DbManage.getConnection();
st = conn.createStatement(); //发送指令集
String sql = "UPDATE tableunis SET user_name = '"+unisVo.getUserName()+"',user_password = '"+unisVo.getInputPassword()+"',user_surepassword = '"+unisVo.getSurePassword()+"',user_sex = '"+unisVo.getUserSex()+"',user_birth='"+unisVo.getUserYear()+"年"+unisVo.getUserMonth()+"月"+unisVo.getUserDay()+"日"+"',user_hobby = '"+unisVo.getUserEnioy()+"',user_native = '"+unisVo.getProvinceInfo()+unisVo.getCityInfo()+"',user_introduce = '"+unisVo.getUserIntroduce()+"' WHERE user_id = '"+unisVo.getUserID()+"'";
//System.out.println(sql);
st.executeUpdate(sql); // 无返回值
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
DbManage.closeDB(st, conn);
}
}
- 查查
- 圈圈查查
- 查查看
- 该查查了
- “查查联盟” 矩阵发展战略
- 查查资料,明天总结
- 头发稀疏查查甲状腺
- Python 爬取企查查数据
- flex 查查你的号码归属地
- 我查查 并行数据处理应对突发流量
- 胖人有这五个病症最好查查血糖
- HTTP劫持后续查查xjcf168.com
- 正则表达式(记不住可以查查)
- 【查查企业:www.chacha360.cn】站点开通
- 【私人记录】东查查西查查一下午搞定了SVM配置MATLAB2012
- 对照你的生日查查你属于哪棵树
- 查查全中国有多少人的名字和你一模一样
- 查查全中国有多少人的名字和你一模一样
- 在 WPF 中创建可换肤的用户界面
- 程序调试--linux下错误的捕获:errno和strerror的使用
- OpenCL Cookbook: Series Reference
- Eclipse上GIT插件EGIT使用手册<转>
- 基于Linux的嵌入式系统全程喂狗策略
- 查查
- 110701 Light, more light
- MAC下GEEK软件推荐
- Linux协议栈代码阅读笔记(三)报文接收
- Ubuntu双显示器分辨率问题
- Runtime exec 执行linux find 命令时 引号问题
- File transfer server could not be started or it exited unexpectedly.Exit value 0 was returned. Most
- C#:Array 的Clear 方法到底有多快???
- LVS的三种模式区别详解