reg.jsp代码如下:
<HTML>
<HEAD>
<TITLE>用户注册</TITLE>
</HEAD><BODY>
<%@page language="java"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="data" scope="page" class="sql.login"/>
<jsp:useBean id="str" scope="page" class="test.str_filter"/>
<%
String name=request.getParameter("name");
String password=request.getParameter("password");
name=name.trim();
password=password.trim();
String sql;
sql="select * from user_table order by id desc";
ResultSet rs=data.executeQuery(sql);
int id=rs.getInt(1);
String id_temp=Integer.toString(id);
if(id_temp==null){
id=1;
}else{
id++;
}
sql="insert into user_table values("+id+",'"+name+"','"+password+"')";
if(data.executeUpdate(sql)){
out.print(str.strtochn("您已经是合法用户。"));
}
data.close();
%>
</BODY>
</HTML>
<HTML>
<HEAD>
<TITLE>用户注册</TITLE>
</HEAD><BODY>
<%@page language="java"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="data" scope="page" class="sql.login"/>
<jsp:useBean id="str" scope="page" class="test.str_filter"/>
<%
String name=request.getParameter("name");
String password=request.getParameter("password");
name=name.trim();
password=password.trim();
String sql;
sql="select * from user_table order by id desc";
ResultSet rs=data.executeQuery(sql);
int id=rs.getInt(1);
String id_temp=Integer.toString(id);
if(id_temp==null){
id=1;
}else{
id++;
}
sql="insert into user_table values("+id+",'"+name+"','"+password+"')";
if(data.executeUpdate(sql)){
out.print(str.strtochn("您已经是合法用户。"));
}
data.close();
%>
</BODY>
</HTML>
解决方案 »
- jsp上传图片,重启tomcat后图片和文件夹自动删除,求解决办法。
- jquery checkbox 选中的值为什么是on
- jsp中 response.setContentType的一些问题
- java正在表达式Pattern和Matcher的疑问
- 显示数据库记录
- 我想知道JAVA WEB跟JSP有什么不一样?还是就是一个东西?
- if(rs.next())和while(rs.next())
- @ 寻《jsp编程指南》电子工业出版(<<profissional jsp>> wrox)的书中例子代码。@
- 求WEBLOGIC连接SQL等数据库的方法和代码?
- 《Java与模式》
- 100分代人问:如何求出两个cachedrowset 数据集的交集??
- 返回值类型的问题!
import java.sql.*;
public class login{
public String UserID="sa";
public String PassWord="";int TYPE_SCROLL_SENSITIVE = 1005;
int CONCUR_UPDATABLE = 1008; String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String sURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=login";
Connection conn=null;
ResultSet rs=null;
Statement stmt; public login(){
try{
Class.forName(sDBDriver);
conn=DriverManager.getConnection(sURL,UserID,PassWord);
stmt=conn.createStatement(rs.TYPE_SCROLL_SENSITIVE,rs.CONCUR_UPDATABLE);
}
catch(java.lang.ClassNotFoundException e){
System.err.println("create():"+e.getMessage());
}
catch(SQLException e){
}
}
public boolean executeUpdate(String sql){
try{
stmt.executeUpdate(sql);
return true;
}catch(SQLException e){
System.err.println("aq.executeUpdate:"+e.getMessage());
}
return false;
}
public ResultSet executeQuery(String sql){
rs=null;
try{
rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
public void close(){
try{
rs.close();
stmt.close();
conn.close();
}catch(Exception e){
System.out.println(e.toString());
}
}
}
String id_temp="";
sql="select * from user_table order by id desc";
ResultSet rs=data.executeQuery(sql);
if(rs.next()){
id=rs.getInt(1);
id_temp=Integer.toString(id);
}
在你的bean里
Statement stmt=null;
不是Statement stmt;