求助数据库连接的问题

hermat 2003-09-29 02:14:17

求助数据库连接的问题!
1请大家帮忙看看,这个数据库错在那里
2我想作一个根CSDN左边选择栏目那样,在左边框架一点,右边框架就会显示出左边选择条目的内容,请问大家这样的如何实现
--------------------------------------------------------
//index.htm

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>登陆系统</title>
</head>
<script language="javascript" src="function.js">
</script>
<!----判断用户输入的内容-----!>
<script language="javascript">
function check_input(){
if(trim(document.theform.name.calue)==""){
alert("请输入内容");
return false;
}
if(trim(document.theform.password.value)==""){
alert("请填入密码");
return false
}
}
</script>
<body>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<table width="75%" border="1">
<tr>
<td width="31%"> </td>
<td width="10%">用户名:</td>
<td width="30%"><form name="form1" method="post" action="">
<input type="text" name="textfield">
</form></td>
<td width="29%"> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>密码:</td>
<td><form name="form2" method="post" action="">
<input type="text" name="textfield2">
</form></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td><form name="form3" method="post" action="login1_2.jsp">
<input type="submit" name="Submit" value="登陆">
</form></td>
<td><form name="form4" method="post" action="">
<input type="submit" name="Submit2" value="取消">
</form></td>
<td> </td>
</tr>
</table>
</body>
</html>
----------------------------------------------------
//login1_2.jsp

<%@ page language="java" import="java.sql.*"%>
<%@ page contentype="text/html;charset=gb2312"%>
<html>
<head>
<title>用户登录</title>
<jsp:usebean id"login" scope="page" class="club.club_test"/>
<%
string name=request.getparameter("name");
string password=request.geparameter("password");
session.putbalue("name",name);
session.putvalue("password",password);
resultset rs;
string sql_1="select*from user_info where name=""+name+""and password=""+password+"";
rs=login.executequery(sql_1);
if(!rs.next())
{%>
<center><h3>请输入用户名,密码错误!<a herf="index.html">返回</a></h3></center>
<%}
else
{
sessuib.putvalue("user_id",rs.getstring("id"));
if(rs.getstring("true_name")==null)
{
%>
</body>
</html>
------------------------------------------------------------------
//javabean:

club_dbconnect.java:
package club;
import java.sql*;

public class club_dbconnect{
string sdbdriver="sun.jdbc.jdbcodbcdriver";
string sconnstr="jdbc:club_test";//club_test 为数据源名
connection conn=null;
resultset rs=null;

public club_dbconnect(){
try{
class.forname(sdbdriver);
}
catch(java.lang.classnotfoundexception e ){
system.err.println("class club_dbconnect not found!"=e.getmessage()");
}
}

public resultset executequery(string sql){
rs=null;
try{
conn=drivermanager.getconnection(sconnstr,"sa","");
statement stmt=conn.createstatement(java.sql.resultset.type_scroll_insensitive.fava.sq;.resultset.concur_read_only);
rs=stmt.executequery(sql);
}
catch(sqlexception ex){
system.err.println("aq.executequery:"+ex.getmessage());
}
return rs;
}
public resultset executeupdate(string sql){
rs=null;
try{
conn=drivermanager.getconnection(sconnstr,"sa","");
statement stmt=conn.createstatement();
rs=stmt.executequery(sql);
}
catch(sqlexception ex){
system.err.println("aq.executequery:"=ex.getmessage());
}
return rs;
}
}

...全文