JSP连接MySQL示例

时间：2007-04-09 来源：linxh

下载mysql驱动程序(Mysql JDBC Driver)
http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.0.5.tar.gz/from/pick
解压后，把里面的mysql-connector-java-5.0.5-bin.jar文件复制到你的tomcat/common/lib下，重启Tomcat，jsp连接mysql的环境就完成。设MySQL中有数据库jsptest create table t (fiel_name varchar(20),v int); 下面是访问数据库的示例程序

<%@ 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/jsptest?user=***&password=***&useUnicode=true&characterEncoding=GB2312" ;
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String query="select * from t";
ResultSet rs=stmt.executeQuery(query);
while(rs.next())
{
        String s=rs.getString("field_name");//字段不是字符型的话就不能用getString,根据字段类使用getBoolean等等
        int i=rs.getInt("v");
        out.println(s+" "+i+"<br>");
}
%>
</body>
</html>