新手求大虾们不要吝赐教。关于jdbc连接Mysql的问题。

Class.forName("org.gjt.mm.mysql.Driver").newInstance();//注册类String url ="jdbc:mysql://"+dbip+":3306/"+use+"?
use应该为数据库名吧

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

org.gjt.mm.mysql.Driver 你得去下mySQL的JDBC驱动
Class.forName("org.gjt.mm.mysql.Driver")；
use为数据库名
String ConnStr = "jdbc:mysql://localhost/user" ;    user 就是连接的数据库
多谢诸位大虾，我改成这样了，可是运行jsp就死着不动了。不知道是何原因。没有驱动？数据库连接不上？。困惑    String url = "jdbc:mysql://localhost:3306/test?user=admin&password=admin&useUnicode=true&characterEncoding=gb2312";
/////jsp在下面<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<title>留言本</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="images/web.css" rel="stylesheet" type="text/css">
</head>
<script language="JavaScript">
function openw(url) {
  var newwin=window.open(url,"NewWin","toolbar=no,resizable=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,top=220,left=220,width=500,height=330");
// newwin.focus();
  return false;
}
function opend(url) {
  var newwin=window.open(url,"NewWin","toolbar=no,resizable=yes,location=no,directories=no,status=no,menubar=no,scrollbars=no,top=100,left=50,width=650,height=350");
// newwin.focus();
  return false;
}
</script>
<body leftmargin="0" topmargin="1">
<jsp:useBean id="wu" scope="page" class="wu.jdbc" />
<%
Connection con = wu.getConn();
Statement stmt = con.createStatement() ;
String sql = "select * from liuyan_temp order by id desc" ;
ResultSet rs = stmt.executeQuery(sql) ;
String pages = request.getParameter("page") ;
int pageInt =  1 ,i=1;
if(pages==null){}else{pageInt = Integer.parseInt(pages);}
while(i<20*(pageInt-1)&&rs.next()){i++ ;}
%>
<table width="775" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
    <td align="center"><img src="images/logo.gif" width="628" height="59" border="1"></td>
  </tr>
  <tr>
    <td>
<table width="100%" border="0" cellpadding="2" cellspacing="1" bgcolor="#16831C">
<tr>
          <td colspan="2" bgcolor="#E8FCE2">
<div align="center">
              <table width="100%" border="0" cellpadding="1" cellspacing="1">
<tr>
                  <td><div align="center"><a href="#" onClick="return opend('ly_new.jsp')">添加留言</a></div></td>
                  <td><div align="center"><a href="http://www.china1024.com">返回主页</a></div></td>
                  <td><div align="center"><a href="login.jsp">留言管理</a></div></td>
                  <td><div align="center"><a href="#" onClick="return opend('my.jsp')">我的介绍</a></div></td>
                </tr>
              </table>
</div></td>
        </tr>
        <%
        i=0 ;
        String str = "#E8FCE2",str1="" ;
        java.util.Random rd = new java.util.Random() ;
        while(rs.next()&i<20){
        i++ ;
        String email = rs.getString("email") ;
        String content = rs.getString("content") ;
         if(str.equals("#E8FCE2")){
         str = "#D1E79E" ;}else{
         str = "#E8FCE2" ;
         }
        %>
        <tr>
<td width="23%" bgcolor="<%=str%>">
<div align="center"><%=rs.getString("sj")%></div></td>
          <td width="77%" bgcolor="<%=str%>">
            <table width="100%" border="0" cellpadding="0" cellspacing="0">
              <tr>
                <td> <div align="center"><a href="<%=rs.getString("url")%>"><img src="images/HOME.gif" alt="个人主页" width="16" height="16" border="0" align="absmiddle"></a>留言人主页</div></td>
                <td> <div align="center"><img src="images/ip.gif" alt="<%=rs.getString("ip")%>" width="13" height="15" align="absmiddle">留言人IP</div></td>
                <td> <div align="center"><a href="mailto:<%=email%>"><img src="images/EMAIL.gif" alt="<%=email%>" width="16" height="16" border="0" align="absmiddle"></a>留言人email</div></td>
                <td> <div align="center"><img src="images/oicq.gif" alt="<%=rs.getString("qq")%>" width="16" height="16" align="absmiddle">留言人QQ</div></td>
                <td><a href="del.jsp?id=<%=rs.getString("id")%>">
                  <div align="center"><img src="images/dele_1.gif" alt="删除" width="14" height="16" border="0" align="absmiddle">删除留言</div>
</a></td>
              </tr>
            </table></td>
        </tr>
        <tr>
<td align="center" valign="middle" bgcolor="<%=str%>"><img src="images/tx/<%=rd.nextInt(30)+1%>.gif" width="100" height="100"><br>
            <br>
            留言人：<%=rs.getString("xm")%> </td>
          <td bgcolor="#FFFFFF">
          <%=content%>
          </td>
        </tr>
        <%
        }
        %>
        <tr bgcolor="#F9CDBB">
<td> </td>
<%
sql = "select count(*) from liuyan_temp" ;
rs = stmt.executeQuery(sql) ;
while(rs.next()) i = rs.getInt(1) ;
%>
          <td>
            <div align="right">总共有留言<%=i%>条/<%=(i+19)/20%>页，这是第<%=pageInt%>页，转到第
            <%
            for(int j=1;j<(i+40)/20;j++){
            %>
            <a href="ly.jsp?page=<%=j%>">^<%=j%>^</a>
            <%
            }
            try {
              rs.close();
              stmt.close();
              con.close();
            }
            catch (Exception ex) {
            }
            %>
            页</div></td>
        </tr>
        <tr>
<td bgcolor="<%=str%>"> </td>
          <td bgcolor="<%=str%>"> </td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td> </td>
  </tr>
</table>
</body>
</html>