JSP连接Mysql数据库

<%@ page contentType="text/html; charset=gb2312" language="java"  
<%@ page contentType="text/html; charset=gb2312" language="java" 
<% 
    //以下几项请自行修改
    String server="localhost";        //MYSQL 服务器的地址
    String dbname="test";        //MYSQL 数据库的名字
    String user="root";            //MYSQL 数据库的登录用户名
    String pass="chfanwsp";        //MYSQL 数据库的登录密码
    String port="3306";            //SQL Server 服务器的端口号，默认为1433
    Connection conn=DBConn.getConnToMySql(server,dbname,user,pass,port);
    Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
                
                String sql="select * from username";
    String sql1="insert into username (uid,pwd) values('梦想年华','梦想年华')";
    stmt.executeUpdate(sql1);
    ResultSet rs=stmt.executeQuery(sql);
    while(rs.next()){
    out.print("用户名:");
    out.print(rs.getString("uid")+" 密码:");
    out.println(rs.getString("pwd")+"
");
    }
    //rs.close();
    //stmt.close();
    //conn.close();
    DBConn.close();
%>