package Util;
import java.sql.*;
/**
* <strong>DBUtil </strong> 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();
}
}
}