java dbutil_java DBUtil

package Util;

import java.sql.*;

/**

* DBUtil is a utility class to create a connection to our

* sample database.

*/

public class DBUtil {

static String driverName = "org.gjt.mm.mysql.Driver";

static String dbUrl = "jdbc:mysql://";

static String dbUser = "root";

static String dbPwd = "123";

public DBUtil() {

}

public static java.sql.Connection connectToDB(String hostName,

String databaseName) throws Exception {

String connName = dbUrl + hostName + ":3306/"

+ databaseName;

Class.forName(driverName).newInstance();

Connection connection = DriverManager.getConnection(connName, dbUser,

dbPwd);

return connection;

}

public static java.sql.Connection connectToDB(String databaseName)

throws Exception {

return (connectToDB("localhost", databaseName));

}

public static java.sql.Connection connectToDB() throws Exception {

return (connectToDB("localhost", "Test"));

}

public static void main(String args[]) {

//try {

//String name = "oracle.jdbc.driver.OracleDriver";

//String url = "jdbc:oracle:thin:@localhost:1521:kevin";

//Class.forName(name).newInstance();

//Connection con = DriverManager.getConnection(url, "kevin", "kevin");

//System.out.println("连接Oracle 9i成功!");

//con.close();

//} catch (Exception e) {

//e.printStackTrace();

//}

//try {

//String name = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

//String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=JavaWeb";

//Class.forName(name).newInstance();

//Connection con = DriverManager.getConnection(url, "sa", "sa");

//System.out.println("连接SQL Server 2000成功!");

//con.close();

//} catch (Exception e) {

//e.printStackTrace();

//}

try {

String name = "org.gjt.mm.mysql.Driver";

String url = "jdbc:mysql://localhost:3306/JavaWeb?useUnicode=true&characterEncoding=gb2312";

Class.forName(name).newInstance();

Connection con = DriverManager.getConnection(url, "root", "root");

System.out.println("连接MySQL 5.0.18成功!(驱动3.1.8)");

PreparedStatement pStmt = null;

ResultSet rs = null;

int id = 0;

String title = null;

String content = null;

String strSql = new String("SELECT * FROM test");

try {

pStmt = con.prepareStatement(strSql,

ResultSet.TYPE_SCROLL_INSENSITIVE,

ResultSet.CONCUR_READ_ONLY);

rs = pStmt.executeQuery();

if(rs.next()) {

id = Integer.parseInt(rs.getString("ID"));

title = rs.getString("Title");

title = new String(title.getBytes("ISO-8859-1"), "GB2312");

content = rs.getString("Content");

content = new String(content.getBytes("ISO-8859-1"), "GB2312");

System.out.println(id);

System.out.println(title);

System.out.println(content);

}

} finally {

try {

rs.close();

pStmt.close();

con.close();

} catch (Exception e) {

e.printStackTrace();

}

}

} catch (Exception e) {

e.printStackTrace();

}

}

}