Java的增删改查（例子）

userDTO（class）

 

package com.softeem.DTO;

public class UserDTO {
 private int userid;
 private String username;
 private int userage;
 
 public UserDTO() {
 
}

public UserDTO(int userid, String username, int userage) {
 super();
 this.userid = userid;
 this.username = username;
 this.userage = userage;
}

public int getUserid() {
 return userid;
}

public void setUserid(int userid) {
 this.userid = userid;
}

public String getUsername() {
 return username;
}

public void setUsername(String username) {
 this.username = username;
}

public int getUserage() {
 return userage;
}

public void setUserage(int userage) {
 this.userage = userage;
}

}

 

 

JDBC（class）

 

 

package com.softeem.JDBC;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DataBaseManage {
 private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
 private static final String UASERNAME="sa";
 private static final String PASSWORD="123";
 private static final String URL="jdbc:sqlserver://localhost:1433;databasename=newsaledb";
 private static Connection conn;
 
 static{
  try {
   Class.forName(DRIVER);
  } catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  
 }
 public static Connection getConn(){
  try {
   
   conn=DriverManager.getConnection(URL, UASERNAME, PASSWORD);
   
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  
  return  conn;
 }

}

 

userDAO（class）

package com.softeem.DAO;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import com.softeem.DTO.UserDTO;
import com.softeem.JDBC.DataBaseManage;

 

public class UserDAO {
private PreparedStatement ps;
private Statement st;
private Connection conn;
private ResultSet rs;

private boolean flag;
private String sql;
//添加数据
public boolean  userAdd(UserDTO db){
 
 try {
  conn=DataBaseManage.getConn();
  sql="insert into users(username,userage) values(?,?)";
  ps=conn.prepareStatement(sql);
     ps.setString(1, db.getUsername());
     ps.setInt(2, db.getUserage());
     flag=!ps.execute();
 } catch (SQLException e) {
  // TODO Auto-generated catch block
  e.printStackTrace();
 }
 return flag;
}

//修改数据
public boolean userUpd(UserDTO db){
 try {
  sql="update users set username=?,userage=? where userid=?";
  conn=DataBaseManage.getConn();
  ps=conn.prepareStatement(sql);
  ps.setString(1, db.getUsername());
  ps.setInt(2, db.getUserage());
  ps.setInt(3, db.getUserid());
  flag=!ps.execute(); 
 } catch (SQLException e) {
  // TODO Auto-generated catch block
  e.printStackTrace();
 }
 return flag;
}
//删除数据
public boolean userDel(UserDTO db){
  try {
   sql="delete from users where userid=?";
   conn=DataBaseManage.getConn();
   ps=conn.prepareStatement(sql);
   ps.setInt(1, db.getUserid());
   flag=!ps.execute();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return flag;
 }
//查询数据
public boolean userSel(){
 try {
  sql="select *from users";
  conn=DataBaseManage.getConn();
  ps=conn.prepareStatement(sql);
  rs=ps.executeQuery();
  while(rs.next()){
   int userid=rs.getInt("userid");
   String username=rs.getString("username");
   int userage=rs.getInt("userage");
   System.out.println(userid+"\t"+username+"\t"+userage);
   System.out.println("----------");
  }
 } catch (SQLException e) {
  // TODO Auto-generated catch block
  e.printStackTrace();
 }
 return flag;
}

 

 public static void main(String[] args) {
  //添加数据的测试
  UserDAO da=new UserDAO();
     UserDTO dt=new UserDTO();
//     dt.setUsername("张杰");
//     dt.setUserage(24);
//     boolean b=da.userAdd(dt);
//     System.out.println(b);
  //修改数据的测试
//  dt.setUsername("李心");
//  dt.setUserage(26);
//  dt.setUserid(3);
//        boolean b=da.userUpd(dt);
//        System.out.println(b);
     //删除数据的测试
//      dt.setUserid(2);
//         boolean b=da.userDel(dt);
//         System.out.println(b);
     //查询数据的测试
     da.userSel();  
 }

}