jsp数据库连接

package MidTerm;
import java.sql.*;
import com.mysql.jdbc.Driver;
public class Connection
{
private static Connection con;
private Statement statement;
private ResultSet rs;
private static String userName="root";
private static String userPassword="123456";
private static String dbName="hoot";
//private static String encoding="characterEncoding=gb2312&useUnicode=true";


private static final String driveName = "com.mysql.jdbc.Driver";
private static String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+
"&password" +  "="+userPassword;

public static synchronized Connection getCon()throws Exception
{
try
{
Class.forName(driveName).newInstance();
con =(Connection) DriverManager.getConnection(url);
return con;
}
catch(SQLException e)
{
System.err.println(e.getMessage());
throw e;
}
}

public Statement getStmntRead()
{
try
{
con = getCon();
statement = ((java.sql.Connection) con).createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
return statement;
}
catch(Exception e)
{