<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<html>
<body>
<%
Connection con;
Statement sql;
ResultSet rss;
try
{
Class.forName("com.mysql.jdbc.Driver");
}
catch(ClassNotFoundException e)
{
out.println("没找到类");
}
try
{
con=DriverManager.getConnection("jdbc:mysql://localhost:3306:mydatabase","root","root");
sql=con.createStatement();
rss=sql.executeQuery("select * from myuserinf");
out.println("succese");
}
catch(SQLException e)
{
out.println("异常!");
}
%>
</body>
</html>
<%@ page import="java.sql.*" %>
<html>
<body>
<%
Connection con;
Statement sql;
ResultSet rss;
try
{
Class.forName("com.mysql.jdbc.Driver");
}
catch(ClassNotFoundException e)
{
out.println("没找到类");
}
try
{
con=DriverManager.getConnection("jdbc:mysql://localhost:3306:mydatabase","root","root");
sql=con.createStatement();
rss=sql.executeQuery("select * from myuserinf");
out.println("succese");
}
catch(SQLException e)
{
out.println("异常!");
}
%>
</body>
</html>
executeUpdate("select * from myuserinf")
还有。。这些问题最好自己找答复...
可以吸取经验...