jsp连接mysql数据库问题

<p>java.lang.String strConn; <br>Class.forName("org.gjt.mm.mysql.Driver").newInstance(); </p>
<p>conn= java.sql.DriverManager.getConnectio("jdbc:mysql://localhost/test","root",""); </p>
<p>%></p>

<p>public class As <br>{ <br>public static void main(String[] args)<br>{ </p>
<p>String str=null; //<br>Statement stmt=null;<br>Connection conn=null;<br>try<br>{<br>Class.forName("com.mysql.jdbc.Driver").newInstance(); <br>//加载驱动程序<br>String url="jdbc:mysql://localhost:3306/qqnumber";<br>String user="root";<br>String password="******"; <br>String sql="select * from qqNumber"; //<br>conn=DriverManager.getConnection(url,user,password); //建立连接<br>stmt=conn.createStatement </p><p>(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); <br>ResultSet rs=stmt.executeQuery(sql); //获得数据结果集合 ResultSet 接口</p>
<p>//提供对数据表的访问。ResultSet 对象通常是通过执行“语句”来生成的<br>rs.next();<br>str=rs.getString("number");<br>System.out.println(str);<br>System.out.println("数据库操作成功，恭喜你");<br>rs.close(); <br>}<br>catch(Exception e)<br>{<br>System.out.println(e);<br>}<br>finally<br>{<br>if(stmt!=null)<br>{<br>try<br>{<br>stmt.close();<br>}<br>catch(SQLException e)<br>{<br>System.out.println(e);<br>}<br>}<br>if(conn!=null)<br>{ <br>try<br>{<br>conn.close();<br>}<br>catch(SQLException e)<br>{<br>System.out.println(e);<br>}<br>}<br>}//finally<br>}//main()</p>
<p>}</p>