package com.javaBean.luo;
import java.sql.*;
public class AddListUser {
private String userName;
private int user;
private String sort;
private String name;
private String mobile;
private String home;
private String office;
private String email;
private String qq;
private String msn;
private String post;
private String address;
private String other;
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getSort() {
return sort;
}
public void setSort(String sort) {
this.sort = sort;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getMobile() {
return mobile;
}
public void setMobile(String mobile) {
this.mobile = mobile;
}
public String getHome() {
return home;
}
public void setHome(String home) {
this.home = home;
}
public String getOffice() {
return office;
}
public void setOffice(String office) {
this.office = office;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getQq() {
return qq;
}
public void setQq(String qq) {
this.qq = qq;
}
public String getMsn() {
return msn;
}
public void setMsn(String msn) {
this.msn = msn;
}
public String getPost() {
return post;
}
public void setPost(String post) {
this.post = post;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getOther() {
return other;
}
public void setOther(String other) {
this.other = other;
}
private Connection conn;
public AddListUser() {
try {
Class.forName("org.gjt.mm.mysql.Driver");
conn = DriverManager.getConnection(
"jdbc:mysql://127.0.0.1:3306/test", "root", "");
} catch (Exception e) {
e.printStackTrace();
}
}
public int findID(){
try {
PreparedStatement pstate = conn
.prepareStatement("select id from users where username=?");
pstate.setString(1, this.getUserName());
ResultSet rs = pstate.executeQuery();
if (rs.next()) {
user=rs.getInt("id");
rs.close();
return user;
}
else return 0;
} catch (Exception e) {
e.printStackTrace();
return 0;
}
}
public boolean insertList() {
try {
int id;
if((id=this.findID())!=0){
PreparedStatement pstate = conn
.prepareStatement("insert into list(user,sort,name,mobile,home,office,email,qq,msn,post,address,other)values(?,?,?,?,?,?,?,?,?,?,?,?)");
pstate.setInt(1,id);
pstate.setString(2, this.getSort());
pstate.setString(3, this.getName());
pstate.setString(4, this.getMobile());
pstate.setString(5, this.getHome());
pstate.setString(6, this.getOffice());
pstate.setString(7, this.getEmail());
pstate.setString(8, this.getQq());
pstate.setString(9, this.getMsn());
pstate.setString(10, this.getPost());
pstate.setString(11, this.getAddress());
pstate.setString(12, this.getOther());
int r = pstate.executeUpdate();
if (r == 1) {
return true;
}
else return false;
}
else
return false;
} catch (Exception e) {
e.printStackTrace();
return false;
}
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
网络百宝箱(应用Jsp开发) (141个子文件)
AddListUser.class 4KB
UpdateList.class 4KB
Register.class 3KB
FindUser.class 3KB
AddNote.class 3KB
AdminLogin.class 2KB
UpdateFav.class 2KB
AddFav.class 2KB
FindList.class 2KB
FindNote.class 2KB
UserLogin.class 2KB
UpdateNote.class 2KB
FindFav.class 2KB
EditListUser.class 2KB
FindNoteContent.class 1KB
FindFavContent.class 1KB
DeleteNote.class 1KB
DeleteList.class 1KB
DeleteFav.class 1KB
.classpath 502B
org.eclipse.wst.jsdt.ui.superType.container 49B
Thumbs.db 86KB
Thumbs.db 7KB
reg.gif 10KB
logo.gif 6KB
m-list.gif 2KB
m-box.gif 2KB
m-access.gif 2KB
m-note.gif 2KB
m-fav.gif 2KB
tdbg1.gif 1KB
un.gif 988B
back.gif 921B
other.gif 898B
first.gif 704B
next.gif 702B
last.gif 698B
vedio.gif 649B
pic.gif 392B
pw.gif 322B
flash.gif 293B
web.gif 254B
music.gif 199B
mysql-connector-java-3.1.12-bin.jar 436KB
jspSmartUpload.jar 14KB
AddListUser.java 3KB
UpdateList.java 3KB
Register.java 2KB
FindUser.java 2KB
AddNote.java 2KB
AdminLogin.java 2KB
AddFav.java 1KB
UpdateFav.java 1KB
FindList.java 1KB
UserLogin.java 1KB
UpdateNote.java 1KB
FindNote.java 1KB
EditListUser.java 830B
FindFav.java 812B
FindNoteContent.java 802B
DeleteList.java 787B
DeleteNote.java 787B
FindFavContent.java 784B
DeleteFav.java 784B
tdbg1.jpg 71KB
login-bg.jpg 23KB
top.jpg 20KB
n-box.jpg 6KB
n-list.jpg 6KB
n-fav.jpg 6KB
n-note.jpg 5KB
n-access.jpg 5KB
logo.jpg 5KB
box.jpg 3KB
fav.jpg 3KB
list.jpg 3KB
welcome.jpg 3KB
list-add.jpg 2KB
fav-add.jpg 2KB
access-add.jpg 2KB
box-upload.jpg 2KB
note-add.jpg 2KB
note.jpg 2KB
tdbg.jpg 1KB
tdbg2.jpg 925B
bg.jpg 913B
.jsdtscope 406B
list.jsp 5KB
adminbox.jsp 4KB
boxl.jsp 4KB
note.jsp 4KB
reEdit.jsp 4KB
fav.jsp 4KB
box-upload.jsp 4KB
list-add.jsp 4KB
reEditFav.jsp 4KB
reg.jsp 4KB
reEditNote.jsp 3KB
fav-add.jsp 3KB
reReg.jsp 3KB
共 141 条
- 1
- 2
资源评论
慢十一拍
- 粉丝: 7
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功