sqlconn.java

来自「一个用jsp开发的网上测试系统」· Java 代码 · 共 42 行

package shenyan.album;
import java.sql.*;
import java.lang.*;

public class SqlConn {


	final String DBDRIVER = "org.gjt.mm.mysql.Driver";
	final String DBURL = "jdbc:mysql://localhost/myalbum";
	final String DBUSER = "root";
	final String DBPASSWORD = "3581489";	
	public Connection conn = null;
	public Statement sqlStmt;
	public ResultSet rs;
	public SqlConn() 
	{
		
	}
	public Connection connectDB()
	{
		try {
			Class.forName(DBDRIVER);
			return conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);
		} catch ( Exception ex ){
			ex.printStackTrace();
		}
		return null;
	}
	public void closeDBConn() 
	{	
		try {
			conn.close();
		} catch ( Exception ex ) {
			ex.printStackTrace();
		} finally {
			conn = null;
		}
	}

}