用jsp编个登陆的代码

jingtangfang 2009-11-07 11:16:22

这是conn.jsp
<%@ page session="true" %>
<%@ page contentType="text/html;charset=gbk" %>
<%@ page pageEncoding="gbk"%>
<%request.setCharacterEncoding("gbk");%>
<%@page import="java.sql.*"
import ="java.util.*"
import ="java.io.*"
contentType="text/html;charset=gbk"
%>

<%
String host="localhost"; //数据库主机
String database="wuym"; //数据库名
String user="sa"; //用户名
String pass="sa"; //口令
String id= request.getParameter("did");

//登记JDBC驱动对象
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
//连接数据库
Connection sqlConn= DriverManager.getConnection ("jdbc:odbc:jsp","sa","sa");
%>
---------------------------------------------------------------------------------------------
下面是ok.jsp
<%@page session="true" %>
<%@ page contentType="text/html;charset=gbk" %>
<%@ page pageEncoding="gbk"%>
<%request.setCharacterEncoding("gbk");%>
<%@page import="java.sql.*"
import="java.util.*"
import="java.io.*"
contentType="text/html;charset=gbk"
%>

<%
Connection sqlConn; //数据库连接对象
Statement sqlStmt; //语句对象
ResultSet sqlRst;

String username=request.getParameter("name1");
String userpwd=request.getParameter("password1");
String sex=request.getParameter("sex");
String minzu=request.getParameter("minzu");
String birth=request.getParameter("birth");
String year1=request.getParameter("year");
String month1=request.getParameter("month");
String number=request.getParameter("number");
String address=request.getParameter("address");
String phone=request.getParameter("phone");

Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver"); //登记JDBC驱动对象

sqlConn= DriverManager.getConnection ("jdbc:odbc:jsp","sa","sa"); //连接数据库
sqlStmt=sqlConn.createStatement();

String sqlQuery="select count(*) from user where name='"+username+"'";
//out.print(sqlQuery);
sqlRst=sqlStmt.executeQuery (sqlQuery);

sqlRst.next();
int count=sqlRst.getInt(1);
//out.print(count);

if(count==1)
{
out.print("<script>alert('此用户已存在请重新注册！');window.location.href='register.jsp'</script>");
}
else
{

String sql="Insert into user(name,password,sex,minzu,birth,number,address,phone) Values('" + username+ "','" + userpwd+ "', '"+sex+"','"+minzu+"','"+year1+month1+"','"+number+"','"+address+"','"+phone+"')";
//out.print(sql);
int n=sqlStmt.executeUpdate(sql);
sqlStmt.close();
sqlConn.close();
}
%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>注册界面</title></head>

<body>
注册成功！请登陆系统。
<form id="form1" name="form1" method="post" action="index.jsp">

<input type="submit" value="登陆" >

<td><input type="hidden" name="username" value="<%=username%>" /></td>
<td><input type="hidden" name="userpwd" value="<%=userpwd%>" /></td>
</form>

</body>

</html>
下面是问题
String sqlQuery="select count(*) from user where name='"+username+"'";
//out.print(sqlQuery);
sqlRst=sqlStmt.executeQuery (sqlQuery);
老说这句错了
很不明白啊
（还有请告诉下怎么创图片）

...全文