conn.java

来自「采用j2ee架构做的bbs」· Java 代码 · 共 43 行

package net.icefish.bean;
import java.sql.*;

public class Conn{
	
	//public Connection conn=null;
	
	public static Connection connection(){
		//public Conn(){
		
		Connection conn=null;

		try{
//		request.setCharacterEncoding("gb2312");
			Class.forName("com.mysql.jdbc.Driver").newInstance(); 
		}
		catch(Exception e){
			System.out.print(e.toString());
		}
	
		try{
			String url="jdbc:mysql://127.0.0.1:3306/icefish?useUnicode=true&characterEncoding=gb2312";  //数据库名统一为icefish,表名与字段名参照概要设计文档
			String user="root";   //设置用户名
			String password="admin";   //设置密码
			conn=DriverManager.getConnection(url,user,password);
		}
		catch(SQLException e){
			System.out.print(e.toString());
		}
		return conn;
	
	}
	
//	public void close(){
//		try{
//			conn.close();
//		}
//		catch(SQLException e){
//			System.out.print(e.toString());	
//		}
//	}
}