Jsp连接MySql

 

jsp连接MySQL数据库 
testmysql.jsp如下： 
<% @ page contentType = " text/html;charset=gb2312 " %>  
<% @ page import = " java.sql.* " %>  
< html >  
< body >  
<% Class.forName( " org.gjt.mm.mysql.Driver " ).newInstance(); 
String url  = " jdbc:mysql://localhost/softforum?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1 "  
// testDB为你的数据库名 
Connection conn =  DriverManager.getConnection(url); 
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 
String sql = " select * from test " ; 
ResultSet rs = stmt.executeQuery(sql); 
while (rs.next())  ... {%> 
您的第一个字段内容为：<%=rs.getString(1)%> 
您的第二个字段内容为：<%=rs.getString(2)%> 
<%} %>  
<% out .print( " 数据库操作成功，恭喜你 " ); %>  
<% rs.close(); 
stmt.close(); 
conn.close(); 
%>  
</ body >  
</ html >