package DBManger;
import java.sql.*;
public class DBManger {
static String url="jdbc:mysql://localhost:3306/jdbcd";
static String user="root";
static String password="aaaa";
static{
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static Connection getConnection() throws SQLException
{
Connection con= DriverManager.getConnection(url, user, password);
return con;
}
public static void dbclose1(Statement st,Connection con)
{
if(st!=null){
try {
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(con!=null)
{
try {
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public static void dbclose(ResultSet rs,Statement st,Connection con)
{
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}dbclose1(st,con);
}
}
package jdbcdemo;
import java.sql.*;
import DBManger.DBManger;
public class demo2 {
public static void main(String[] args) {
demo2 db=new demo2();
//db.select();
db.insert();
//db.delete();
//db.update();
}
public void insert()
{
Connection con=null;
Statement st=null;
try{
con=DBManger.getConnection();
st=con.createStatement();
int i =st.executeUpdate("insert into users(name,password,email,birthday) values('zs','abcd','zs@126.com','1983-11-11')");
if(i>0){
System.out.println("插入成功");
}
}
catch(SQLException e){
e.printStackTrace();
}finally{
DBManger.dbclose1(st,con);
}
}
public void update()
{
Connection con=null;
Statement st=null;
try{
con=DBManger.getConnection();
st=con.createStatement();
int i =st.executeUpdate("update users set name='bb' where id=2");
if(i>0){
System.out.print("修改成功");
}
}
catch(SQLException e){
e.printStackTrace();
}finally{
DBManger.dbclose1(st,con);
}
}
public void delete()
{
Connection con=null;
Statement st=null;
try{
con=DBManger.getConnection();
st=con.createStatement();
int i =st.executeUpdate("delete from users set where id=1");
if(i>0){
System.out.println("删除成功");
}
}
catch(SQLException e){
e.printStackTrace();
}finally{
DBManger.dbclose1(st,con);
}
}
public void select()
{
Connection con=null;
Statement st=null;
ResultSet rs=null;
try{
con=DBManger.getConnection();
st=con.createStatement();
rs=st.executeQuery("select id,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{
DBManger.dbclose(rs,st,con);
}
}
}