mysqldao.java

用jsp编写的网上投票系统

package votebean;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
 * @author xiaoq
 *
 */
//sqldao
public class MysqlDAO {
	//private static Statement sta;
	private static Connection conn;
	public static Connection getConnection() throws SQLException , java.lang.ClassNotFoundException{ 
		String url = "jdbc:mysql://localhost:3306/xiaoq"; 
		Class.forName("com.mysql.jdbc.Driver"); 
		String userName = "root"; 
		String password = "304092"; 
		Connection con = DriverManager.getConnection(url,userName,password);
		return con; 
		}
	public static void freeConn(){
		try{
			if(conn!=null){
				conn.close();
			}
		}catch(Exception e){
			e.getStackTrace();
		}
	}
}