dbutil.java

这是一个公告管理系统

package nm;

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 = "root";

	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", "noticemanager"));
	}

	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 notice");
			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();
		}
	}
}