java jdbc bean_JAVA + MYSQL + JDBC Bean范例 | 学步园

//连接数据库的Java Bean文件名dbconn.java

package NinGoo;

import java.sql.*;

public class dbconn {

public dbconn() {

}

//declare variable

private Connection conn = null;

ResultSet rs = null;

private String server = "127.0.0.1";

private String port = "3306";

private String db = "test";

private String user = "root";

private String pass = "password";

private String drivername="com.mysql.jdbc.Driver";

private String URL="jdbc:mysql://"+server+":"+port+"/"+db+"?user="+user+"&password="+pass;

public Connection getConn(){//get database connection

try{

Class.forName(drivername).newInstance();

conn = DriverManager.getConnection(URL);

}

catch(Exception e){

e.printStackTrace();

}

return this.conn ;

}

public ResultSet executeSQL(String str) {

try{

Statement stmt = conn.createStatement();

rs = stmt.executeQuery(str);

}

catch(Exception e){

e.printStackTrace();

}

return this.rs;

}

}

原文出处:http://ningoo.itpub.net/