pre.setObject(i+1,o[i]);
}
intcount=pre.executeUpdate();
returncount;
}catch(SQLExceptione){
e.printStackTrace();
return0;
}
}
publicvoidclose(){
try{
if(rs!
=null){
rs.close();
}
pre.close();
con.close();
}catch(SQLExceptione){
e.printStackTrace();
}
}
}
业务层
publicclassLoginService{
privateDBdb;
privatestaticLoginServiceservice;
privateLoginService(){
db=DB.getInstance();
}
publicstaticLoginServicegetInstatnce(){
if(service==null){
service=newLoginService();
}
returnservice;
}
publicbooleanlogin(Loginlo){
Stringsql="select*fromt_loginwhereusername=?
andpassword=?
";
ResultSetrs=db.executeQueryByParam(sql,lo.getUsername(),lo.getPassword());
try{
if(rs.next()){
returntrue;
}
}catch(SQLExceptione){
e.printStackTrace();
}finally{
db.close();
}
returnfalse;
}
publicbooleanregister(Loginlo){
Stringsql="insertintot_login(username,password)values(?
?
)";
intcount=db.executeUpdate(sql,lo.getUsername(),lo.getPassword());
db.close();
if(count>0){
returntrue;
}else{
returnfalse;
}
}
}
publicclassUserService{
privateDBdb;
privatestaticUserServiceservice;
privateUserService(){
db=DB.getInstance();
}
publicstaticUserServicegetInstance(){
if(service==null){
service=newUserService();
}
returnservice;
}
publicListgetAllUsers(){
Stringsql="select*fromt_user";
ResultSetrs=db.executeQueryNoParam(sql);
Listusers=null;
try{
users=this.getList(rs);
}catch(SQLExceptione){
e.printStackTrace();
}finally{
db.close();
}
returnusers;
}
publicListqueryUsersByName(Stringname){
Stringsql="select*fromt_userwherenamelike?
";
ResultSetrs=db.executeQueryByParam(sql,"%"+name+"%");
Listusers=null;
try{
users=this.getList(rs);
}catch(SQLExceptione){
e.printStackTrace();
}finally{
db.close();
}
returnusers;
}
privateListgetList(ResultSetrs)throwsSQLException{
Listusers=newArrayList();
Useruser;
while(rs.next()){
user=newUser();
user.setId(rs.getInt
(1));
user.setName(rs.getString
(2));
user.setMoney(rs.getInt(3));
user.setTime(rs.getDate(4));
users.add(user);
}
returnusers;
}
publicbooleaninsertOneUser(Stringname,doublemoney,Datetime){
Stringsql="insertintot_user(name,money,time)values(?
?
?
)";
intcount=db.executeUpdate(sql,name,money,time);
db.close();
if(count>0){
returntrue;
}else{
returnfalse;
}
}
publicbooleandeleteUserById(intid){
Stringsql="deletefromt_userwhereid=?
";
intcount=db.executeUpdate(sql,id);
db.close();
if(count>0){
returntrue;
}else{
returnfalse;
}
}
publicbooleanupdateUser(intid,Stringname,doublemoney,Datetime){
Stringsql="updatet_usersetname=?
money=?
time=?
whereid=?
";
intcount=db.executeUpdate(sql,name,money,time,id);
db.close();
if(count>0){
returntrue;
}else{
returnfalse;
}
}
publicUsergetUserById(intid){
Stringsql="select*fromt_userwhereid=?
";
ResultSetrs=db.executeQueryByParam(sql,id);
try{
if(rs.next()){
Useruser=newUser();
user.setId(id);
user.setName(rs.getString
(2));
user.setMoney(rs.getInt(3));
user.setTime(rs.getDate(4));
returnuser;
}
}catch(SQLExceptione){
e.printStackTrace();
}finally{
db.close();
}
returnnull;
}
}
Controller类
publicclassController{
publicvoidcontroller()throwsInputMismatchException{
Scannerscan=newScanner(System.in);
while(true){
MainView.showMain();
System.out.println("pleaseselectyouroperation:
");
System.out.println("1.insert2.delete3.modify4.query5.exit");
inti=scan.nextInt();
UserServiceservice=UserService.getInstance();
Operationo=null;
booleanflag=true;
switch(i){
case1:
o=newAddView();
break;
case2:
o=newDeleteView();
break;
case3:
o=newModifyView();
break;
case4:
o=newQueryView();
break;
case5:
System.out.println("Bye~~~~~~~~~");
return;
default:
//scan.close();
System.out.println("inputerror,pleaseinput1~5!
");
flag=false;
}
if(flag){
o.operation(service);
}
}
}
}
视图层
publicclassMainView{
publicstaticvoidstart(){
Scannerscan=newScanner(System.in);
while(true){
LoginServiceservice;
System.out.println("pleaseinputyouraccountandpasswordtologin,enter1forregisteronenewuser.");
Stringusername=scan.next();
Stringpassword;
while("1".equals(username)){
System.out.println("pleaseinputaccount:
");
StringnewUsername=scan.next();
StringnewPwd;
while(true){
System.out.println("pleaseinputpassword:
");
newPwd=scan.next();
System.out.println("pleaseinputconfirmationpassword:
");
StringconfirmPwd=scan.next();
if(newPwd.equals(confirmPwd)