dbfactory.java

完整的代码

package org.fish_bone.chatting.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * createTime:2008-9-10 下午03:33:38 source:http://www.taxchina.com
 * file_PATH:org.fish_bone.chatting.dbDBFactory.java project_name:jqueryChatting
 * author:lee
 */

public class DBFactory {
	Connection conn;

	Statement st;

	ResultSet rs;

	public Connection getConnection() {
		String driverName = "com.mysql.jdbc.Driver";
		// 数据库用户名

		String userName = "root";

		// 密码

		String userPasswd = "root";

		// 数据库名

		String dbName = "test";
		String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			
			e.printStackTrace();
		}

		try {
			 conn=DriverManager.getConnection(url);
			 System.out.println("lianjie");
		} catch (SQLException e) {
			
			e.printStackTrace();
		}

		return conn ;

	}
public static void main(String[] args) {
	DBFactory dbf =  new DBFactory();
	dbf.getConnection() ;
	
}
}