81,092
社区成员
发帖
与我相关
我的任务
分享MySQL的小问题
MySQL装在D:下面：
数据库test里有个表test 字锻就二个id,name
localhostname：yzj
localusername:yzj1
localip:192.168.0.201
现在在jsp里怎么调用啊，我写的代码那里有问题？
<%@ page info="database handler"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<%@ page contentType="text/html;charset=8859_1" %>
<%
//声明
java.sql.Connection sqlConn;//数据库连接对象
java.sql.Statement sqlStmt;//语句对象
java.sql.ResultSet sqlRst;//结果集对象
//登记JDBC驱动程序
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
//连接数据库
sqlConn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost/test","test","test");
//创建语句对象
sqlStmt =
sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_O
NLY);
//执行SQL语句
sqlRst = sqlStmt.executeQuery("SELECT id,name from test");
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>Windows-JSP-JDBC-MySQL测试 - Select</title>
</head>
<body>
<table border="1" cellspacing="0" cellpadding="0" align="center">
<tr>
<th>ID</th>
<th>名称</th>
</tr>
<%while(sqlRst.next()){%>
<tr>
<td><%=sqlRst.getString(1)%></td>
<td><%=sqlRst.getLong(2)%></td>
</tr>
<%}%>
</table>
</body>
</html>
<%
//关闭结果集对象
sqlRst.close();
//关闭语句对象
sqlStmt.close();
//关闭数据库连接
sqlConn.close();
%>
********************
主要是这二句不知道怎么设置
sqlConn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost/test","test","test");
//创建语句对象
sqlStmt = sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
数据库test里有个表test 字锻就二个id,name
localhostname：yzj
localusername:yzj1
localip:192.168.0.201
现在在jsp里怎么调用啊，我写的代码那里有问题？
<%@ page info="database handler"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<%@ page contentType="text/html;charset=8859_1" %>
<%
//声明
java.sql.Connection sqlConn;//数据库连接对象
java.sql.Statement sqlStmt;//语句对象
java.sql.ResultSet sqlRst;//结果集对象
//登记JDBC驱动程序
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
//连接数据库
sqlConn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost/test","test","test");
//创建语句对象
sqlStmt =
sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_O
NLY);
//执行SQL语句
sqlRst = sqlStmt.executeQuery("SELECT id,name from test");
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>Windows-JSP-JDBC-MySQL测试 - Select</title>
</head>
<body>
<table border="1" cellspacing="0" cellpadding="0" align="center">
<tr>
<th>ID</th>
<th>名称</th>
</tr>
<%while(sqlRst.next()){%>
<tr>
<td><%=sqlRst.getString(1)%></td>
<td><%=sqlRst.getLong(2)%></td>
</tr>
<%}%>
</table>
</body>
</html>
<%
//关闭结果集对象
sqlRst.close();
//关闭语句对象
sqlStmt.close();
//关闭数据库连接
sqlConn.close();
%>
********************
主要是这二句不知道怎么设置
sqlConn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost/test","test","test");
//创建语句对象
sqlStmt = sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
...全文
请发表友善的回复…
发表回复
snake_eye 2003-08-11
- 打赏
- 举报
是不是要一个jdbc驱动的jar文件啊？
从那里可以下载到？
从那里可以下载到？
snake_eye 2003-08-11
- 打赏
- 举报
jdbc的驱动程序放到服务器的类路径里是怎么一回事啊》？
gzh_seagull 2003-08-11
- 打赏
- 举报
用户和密码不对 :)
sgdb 2003-08-11
- 打赏
- 举报
sqlConn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost/test?user=test&passwoed=test");
sqlStmt =sqlConn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sqlStmt =sqlConn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sgdb 2003-08-11
- 打赏
- 举报
sqlConn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost/test?user=test&passwoed=test");
sqlStmt =sqlConn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sqlStmt =sqlConn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
