java连接mysql封装代码_自己封装的java连接mysql的类

本人初学，希望大家提出宝贵意见

1.[文件] MySqlClass.java ~ 2KB     下载(183)

/*

* To change this template, choose Tools | Templates

* and open the template in the editor.

*/

package classinfo;

import java.sql.*;

/**

*

* @author mystyle

*/

public class MySqlClass {

private Connection conn=null;

private Statement st=null;

private ResultSet rs=null;

public MySqlClass(String databaseName,String userName,String password){

try{

//写入驱动所在处，打开驱动

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

//数据库，用户，密码，创建与具体数据库的连接

conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/"+databaseName,userName,password);

//创建执行sql语句的对象

st=conn.createStatement();

}catch(Exception e){

javax.swing.JOptionPane.showMessageDialog(null,"连接失败"+e.toString());

}

}

public String query(String sqlStatement,int n){

String result="";

try{

rs=st.executeQuery(sqlStatement);

while(rs!=null && rs.next()){

result=rs.getString(n);

//列的记数是从1开始的，这个适配器和C#的不同

}

rs.close();

return result;

}catch(Exception e){

javax.swing.JOptionPane.showMessageDialog(null,"查询失败"+e.toString());

return "";

}

}

public int query(String sqlStatement){

int row=0;

try{

row=st.executeUpdate(sqlStatement);

this.close();

return row;

}catch(Exception e){

javax.swing.JOptionPane.showMessageDialog(null,"执行sql语句失败"+e.toString());

this.close();

return row;

}

}

public void close(){

try{

this.rs.close();

this.st.close();

this.conn.close();

}catch(Exception e){

javax.swing.JOptionPane.showMessageDialog(null,"关闭数据库连接失败"+e.toString());

}

}

}

2.[文件] MySqlClass.java ~ 2KB     下载(82)

/*

* To change this template, choose Tools | Templates

* and open the template in the editor.

*/

package classinfo;

import java.sql.*;

/**

*

* @author mystyle

*/

class MySqlClass {

private Connection conn=null;

private Statement st=null;

private ResultSet rs=null;

public MySqlClass(String databaseName,String userName,String password){

try{

//写入驱动所在处，打开驱动

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

//数据库，用户，密码，创建与具体数据库的连接

conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/"+databaseName,userName,password);

//创建执行sql语句的对象

st=conn.createStatement();

}catch(Exception e){

javax.swing.JOptionPane.showMessageDialog(null,"连接失败"+e.toString());

}

}

public String query(String sqlStatement,int n){

String result="";

try{

rs=st.executeQuery(sqlStatement);

while(rs!=null && rs.next()){

result=rs.getString(n);

//列的记数是从1开始的，这个适配器和C#的不同

}

rs.close();

return result;

}catch(Exception e){

javax.swing.JOptionPane.showMessageDialog(null,"查询失败"+e.toString());

return null;

}

}

public int query(String sqlStatement){

int row=0;

try{

row=st.executeUpdate(sqlStatement);

this.close();

return row;

}catch(Exception e){

javax.swing.JOptionPane.showMessageDialog(null,"执行sql语句失败"+e.toString());

this.close();

return row;

}

}

public void close(){

try{

if(rs!=null)

this.rs.close();

if(st!=null)

this.st.close();

if(conn!=null)

this.conn.close();

}catch(Exception e){

javax.swing.JOptionPane.showMessageDialog(null,"关闭数据库连接失败"+e.toString());

}

}

}