该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

import javax.swing.*;

import java.sql.*;

public class DataBase

{

Connection con=null;//声明Connection引用

Statement stat=null;

ResultSet rs=null;

int count;

//public static Login log;

public DataBase(){

try{//加载MySQL的驱动类，并创建数据库连接

Class.forName("org.gjt.mm.mysql.Driver");

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

con=DriverManager.getConnection("jdbc:mysql://locahost:3306/library4","root","root");

stat=con.createStatement();//创建Statement对象

}

catch(Exception e){

System.out.println("加载驱动失败");

}

}

public void selectDb(String sql){//声明select方法

try{

if(rs==null){

System.out.println("rs is null");

return;

}

rs=stat.executeQuery(sql);

}

catch(Exception ie){ie.printStackTrace();}

}

public int updateDb(String sql){//声明update方法

try{

sql = new String(sql.getBytes("gb2312"));//转码

count=stat.executeUpdate(sql);

}

catch(Exception ie){ie.printStackTrace();}

return count;

}

public void dbClose(){//声明close方法

try{

stat.close();

con.close();}

catch(Exception e){e.printStackTrace();}

}

public static void main(String[]args)

{

DataBase db=new DataBase();

}

}