贵阳最火的休闲会所:连接数据库测试有误,代码如下.请各位指点.

来源：百度文库编辑：高校问答时间：2024/05/05 16:48:26

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import = "com.DealString.DealString"%>
<jsp:useBean id="dealString" scope="page" class="com.DealString.DealString"></jsp:useBean>

<%
try{
Class.forName("com.mysql.jdbc.Driver");
}catch (Exception ex){
out.println(ex.toString());
}
//获取数据库连接
Connection conn = null;
try{
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/room?user=root&password=123&useUnicode=true&characterEncoding=gb2312");
}catch (SQLException ex){
out.println(ex.toString());
}
%>
<%java.sql.PreparedStatement pstmt = null;
if(conn != null)
{
String sql = "insert Into userinfo(username,realname,passwd,repassword,sex,email,province,city,tel,mob,adress,role,onrole) values (?,?,?,?,?,?,?,?,?,?,?,?,?)";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1,username);
pstmt.setString(2,realname);
pstmt.setString(3,passwd);
pstmt.setString(4,repassword);
pstmt.setString(5,email);
pstmt.setString(6,sex);
pstmt.setString(7,tel);
pstmt.setString(8,mob);
pstmt.setString(9,province);
pstmt.setString(10,city);
pstmt.setString(11,adress);
pstmt.setString(12,onrole);
pstmt.setString(13,role);

pstmt.execute(); //执行sql
ResultSet rst = pstmt.executeQuery( "Select * from userinfo");

while(rst.next())
{
username = rst.getString("username");
realname = rst.getString("realname");
passwd = rst.getString("passwd");
repassword = rst.getString("repassword");
sex =rst.getString("sex");

tel = rst.getString("tel");
mob = rst.getString("mob");
email = rst.getString("email");
province = rst.getString("province");
city = rst.getString("city");

role = rst.getString("role");
onrole = rst.getString("onrole");

}
pstmt.close();

}

conn.close();
%><%out.print("操作成功");%>

<html>
<head>

<title></title>
</head>

<body>
</body>
</html>

把错误提示贴出来

连接数据库测试有误,代码如下.请各位指点. 数据库问题，请各位高手指点一下~！~！！ vb关于连接数据库问题（高手请指点）请高手指点菜鸟,VB怎样连接ACCESS数据库 ASP函数调用，前台为何出现的是代码，请各位大侠帮帮忙，谢谢！代码如下：我的修改代码如下，但是始终不能实现，请高手指点连接数据库的代码格式？ VB.NET连接数据库代码密码没错,QQ登陆不了,问题如下:请各位给予指点 J2EE连接SqlServer数据库时用windows身份验证登陆要怎么写代码？各位高手指教！