11级_Java_曹建波6.18 JDBC开发2

JDBC开发2

DBManager

package com.hbsi.dbUtil;

import java.sql.*;

public class DBManager {

static String url="jdbc:mysql://localhost:3306/jdbcdb";

static String user="root";

static String password="root";

static{

try {

Class.forName("com.mysql.jdbc.Driver");

}catch (ClassNotFoundException e) {

// TODO Auto-generatedcatch block

e.printStackTrace();

}

}

public static ConnectiongetConnection() throws SQLException{

Connectioncon=DriverManager.getConnection(url,user,password);

return con;

}

public static void dbClose1(Statementst,Connection con){

if(st!=null){

try {

st.close();

}catch (SQLException e) {

// TODO Auto-generatedcatch block

e.printStackTrace();

}

}

if(con!=null){

try {

con.close();

}catch (SQLException e) {

// TODO Auto-generatedcatch block

e.printStackTrace();

}

}

}

public static void dbClose(ResultSetrs,Statement st,Connection con){

if(rs!=null){

try {

rs.close();

}catch (SQLException e) {

// TODO Auto-generatedcatch block

e.printStackTrace();

}

}

dbClose1(st,con);

}

}

Demo2

package com.hbsi.jdbcdemo;

import java.sql.*;

importcom.hbsi.dbUtil.DBManager;

importjava.sql.Connection;

public class Demo2 {

/**

* @param args

*/

public static void main(String[]args) {

Demo2d2=new Demo2();

d2.insert();

//d2.update();

//d2.delete();

d2.select();

}

public void insert(){

Connectioncon=null;

Statementst=null;

try{

con=DBManager.getConnection();

st=con.createStatement();

inti=st.executeUpdate("insert intousers(id,name,password,email,birthday) values(4,'zs','abcd','zs@126.com','1983-11-11')");

if(i>0){

System.out.println("插入成功！！");

}

}catch(SQLException e){

e.printStackTrace();

}finally{

DBManager.dbClose1(st,con);

}

}

public void update(){

Connectioncon=null;

Statementst=null;

try{

con=DBManager.getConnection();

st=con.createStatement();

inti=st.executeUpdate("update users set password='abcd'where id=1");

if(i>0){

System.out.println("修改成功!!");

}

}catch(SQLException e){

e.printStackTrace();

}finally{

DBManager.dbClose1(st,con);

}

}

public void delete(){

Connectioncon=null;

Statementst=null;

try{

con=DBManager.getConnection();

st=con.createStatement();

inti=st.executeUpdate("delete from users where id=2");

if(i>0){

System.out.println("删除成功!!");

}

}catch(SQLException e){

e.printStackTrace();

}finally{

DBManager.dbClose1(st,con);

}

}

public void select(){

Connectioncon=null;

Statementst=null;

ResultSetrs=null;

try{

con=DBManager.getConnection();

st=con.createStatement();

rs=st.executeQuery("selectid,name,password from users");

while(rs.next()){

System.out.print(rs.getInt("id"));

System.out.print("\t"+rs.getString("name"));

System.out.println("\t"+rs.getString("password"));

}

}catch(SQLException e){

e.printStackTrace();

}finally{

DBManager.dbClose(rs,st, con);

}

}

}