<html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%@ page contentType="text/html;charset=ISO8859_1"%>
<!--不支持用out.print输出中文-->
<title>JSP-JDBC网页</title>
</head>
<body>
<%@ page language="java" import="java.io.* java.sql.*"%>
<%
java.sql.Connection sqlconn;
Class.forName("com.caucho.jdbc.mysql.Driver").newInstance();
//MYSQL驱动程序名
sqlconn=java.sql.DriverManager.getConnection("jdbc:mysql_caucho://localhost:3306/mydata","root","");
//mydata是数据库名,root默认用户名,密码(默认为空)
Statement stmt=null;
stmt=sqlconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
%>
<%
String selsql="select * from mytable";
ResultSet result=stmt.executeQuery(selsql);
out.println("<table border=1>");
while(result.next())
{
out.println("<tr><td>");
out.println(result.getInt("Msg_ID"));
//Msg_ID字段名
out.println("</td>");
out.println("<td>");
out.println(result.getString("Msg_Title"));
out.println("</td>");
out.println("<td>");
out.println(result.getString("Msg_Author"));
out.println("</td>");
out.println("<td>");
out.println(result.getString("Msg_Context"));
out.println("</td>");
out.println("<td>");
out.println(result.getDate("Msg_Time"));
out.println("</td></tr>");
}
//getTime时间
out.println("</table>");
result.close();
stmt.close();
sqlconn.close();
%>
<%!
public String GBK2UNI(String s)
throws UnsupportedEncodingException
{
String temp=s;
temp=new String(s.getBytes("GBK"),"ISO8859_1");
return temp;
}
%>
//转换函数,使out.println(GBK2UNI(str1));输出汉字
<%
String str1;
str1="数据库操作成功,恭喜你!";
out.println(GBK2UNI(str1));
%>
<font color='red' size='5'>连接Mysql数据库!</font>
</body>
</html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%@ page contentType="text/html;charset=ISO8859_1"%>
<!--不支持用out.print输出中文-->
<title>JSP-JDBC网页</title>
</head>
<body>
<%@ page language="java" import="java.io.* java.sql.*"%>
<%
java.sql.Connection sqlconn;
Class.forName("com.caucho.jdbc.mysql.Driver").newInstance();
//MYSQL驱动程序名
sqlconn=java.sql.DriverManager.getConnection("jdbc:mysql_caucho://localhost:3306/mydata","root","");
//mydata是数据库名,root默认用户名,密码(默认为空)
Statement stmt=null;
stmt=sqlconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
%>
<%
String selsql="select * from mytable";
ResultSet result=stmt.executeQuery(selsql);
out.println("<table border=1>");
while(result.next())
{
out.println("<tr><td>");
out.println(result.getInt("Msg_ID"));
//Msg_ID字段名
out.println("</td>");
out.println("<td>");
out.println(result.getString("Msg_Title"));
out.println("</td>");
out.println("<td>");
out.println(result.getString("Msg_Author"));
out.println("</td>");
out.println("<td>");
out.println(result.getString("Msg_Context"));
out.println("</td>");
out.println("<td>");
out.println(result.getDate("Msg_Time"));
out.println("</td></tr>");
}
//getTime时间
out.println("</table>");
result.close();
stmt.close();
sqlconn.close();
%>
<%!
public String GBK2UNI(String s)
throws UnsupportedEncodingException
{
String temp=s;
temp=new String(s.getBytes("GBK"),"ISO8859_1");
return temp;
}
%>
//转换函数,使out.println(GBK2UNI(str1));输出汉字
<%
String str1;
str1="数据库操作成功,恭喜你!";
out.println(GBK2UNI(str1));
%>
<font color='red' size='5'>连接Mysql数据库!</font>
</body>
</html>
tomcat/common/lib下有该jar包吗?
问个菜点的问题,MYSQL的JDBC驱动程序包路径是在哪里?