JDBC开发2
DBManager
package com.hbsi.dbUtil;
import java.sql.*;
public
class DBManager {
static Stringurl="jdbc:mysql://localhost:3306/jdbcdb";
static Stringuser="root";
static Stringpassword="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);
}
}
}