sqlconnection.java

java语言中servlet的用法实例

package blogServlet;

import java.sql.Connection;
import java.sql.DriverManager;
public class SqlConnection {
	//数据库驱动
	public static String  databaseDriver;
	//数据库类型
	public static String  databaseType;
	//服务器IP
	public static String  host;
	//服务器开启端口
	public static String  port;
	//数据库名
	public static String  databaseName;
	//数据库URL
	//public static String jdbcURL = "jdbc:"+databaseType+"://"+host+":"+port+"/"+databaseName;
	//登录用户名
	public static String dbUserName;
	//登录密码
	public static String databasePwd;
	//要创建返回的数据库连接对象
	private java.sql.Connection conn;
	
	public java.sql.Connection getConn()throws Exception{
		if(null!=conn)
			return conn;
		Class.forName(databaseDriver).newInstance();
		//2.连接数据库
		String jdbcURL = "jdbc:"+databaseType+"://"+host+":"+port+"/"+databaseName;
		java.sql.Connection conn = java.sql.DriverManager.getConnection(jdbcURL,dbUserName,databasePwd);
		return conn;
	}
}