数据库增删改查

DBConfig.java

public interface DBConfig {
 String driver ="com.mysql.jdbc.Driver";
 String url="jdbc:mysql://localhost:3306/weirong";
 String user="root";
 String password="111111";

}

 

ControlDB.java

import java.sql.*;

public class ControlDB implements DBConfig{

 public static void main(String[] args) {
  try{
   Class.forName(driver);//加载数据库驱动程序
  }catch(ClassNotFoundException e){
   e.printStackTrace();
  }
  Connection conn = null;
  try{
   conn = DriverManager.getConnection(url, user, password);//获得connection对象
  }catch(SQLException e){
   e.printStackTrace();
  }
  Statement stat = null;
  try{
   stat =conn.createStatement();//获得Statement对象
  }catch(SQLException e){
   e.printStackTrace();
  }
//  String sql = "create table student(id int primary key auto_increment,name varchar(20),gender char(2),age int,department varchar(50),email varchar(50));";//SQL语句
//  String sql1 = "insert into student(id,name,gender,sge,department,email)value('2','小王','女','30','软件','xiaongwang@123.com')";
//  String sql2 = "update student set department = 'ruanjian'where department='软件'";
  String sql3 = "select * from student;";
  ResultSet rs =null;
  try{
//   stat.executeUpdate(sql2);//执行SQL语句
   rs = stat.executeQuery(sql3);//使用SQL语句查询
   StringBuilder sb = new StringBuilder();
   while(rs.next()){
    sb.delete(0, sb.capacity());//将对象中的数据清空
    sb.append("序号："+rs.getInt("id")+" ");
    sb.append("姓名："+rs.getString("name")+" ");
    sb.append("性别："+rs.getString("gender")+"\n");
    System.out.println(sb.toString());
   }
  }catch(SQLException e){
   e.printStackTrace();
  }finally{
   try{
    rs.close();
   }catch(SQLException e){
    e.printStackTrace();
   }
   try{
    stat.close();//关闭Statement
   }catch(SQLException e){
    e.printStackTrace();
   }
   try{
    conn.close();//关闭Connection
   }catch(SQLException e){
    e.printStackTrace();
   }
   
  }
  // TODO Auto-generated method stub

 }

}