项目里用到的。我直接贴了啊。。JDBC连接数据库的类,你自己写<%@ page language="java" errorPage="" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.text.*" %>
<%@ page import = "database.JDBC" %>
<%@ page contentType="text/html;charset=GB2312"%>
<jsp:useBean id="jdbc" scope="page" class="database.JDBC"/>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>申请网上商城用户</title>
<%
boolean flag = true;
int wuid = 0;
String vip_no ="" ;
int hyjf = 0;
String uzh = "";
String name = "";
String sex = "";
String pass = "";
String paqu = "";
String panser = "";
String birth = "";
String job = "";
String xl = "";
String sl = "";
String sfzh = "";
String email = "";
String cydh= "";
String gj = "";
String ss = "";
String xq = "";
String shdz = "";
String yzbm = "";
String sfdy = "";
String gxrq = "";
String gxr = "";
String cz="";
uzh=new String(request.getParameter("sc_name").getBytes("ISO8859_1"));
if(request.getParameter("vip_no")!=null) vip_no = jdbc.convertStr(request.getParameter("vip_no"));
//if(Integer.parseInt(request.getParameter("hyjf"))>0) vip_no = Integer.parseInt(request.getParameter("hyjf"));
// if(Integer.parseInt(request.getParameter("SEX"))>0) SEX = Integer.parseInt(request.getParameter("SEX"));
if(request.getParameter("name")!=null) name = jdbc.convertStr(request.getParameter("name"));
if(request.getParameter("sex")!=null) sex = jdbc.convertStr(request.getParameter("sex"));
if(request.getParameter("mima1")!=null) pass = jdbc.convertStr(request.getParameter("mima1"));
if(request.getParameter("paqu")!=null) paqu = jdbc.convertStr(request.getParameter("paqu"));
if(request.getParameter("panser")!=null) panser = jdbc.convertStr(request.getParameter("panser"));
if(request.getParameter("CSRQ")!=null) birth = jdbc.convertStr(request.getParameter("CSRQ"));
if(request.getParameter("job")!=null) job = jdbc.convertStr(request.getParameter("job"));
if(request.getParameter("xl")!=null) xl = jdbc.convertStr(request.getParameter("xl"));
if(request.getParameter("sl")!=null) sl = jdbc.convertStr(request.getParameter("sl"));
if(request.getParameter("sfzh")!=null) sfzh = jdbc.convertStr(request.getParameter("sfzh"));
if(request.getParameter("email")!=null) email = jdbc.convertStr(request.getParameter("email"));
if(request.getParameter("cydh")!=null) cydh = jdbc.convertStr(request.getParameter("cydh"));
if(request.getParameter("gj")!=null) gj = jdbc.convertStr(request.getParameter("gj"));
if(request.getParameter("ss")!=null) ss = jdbc.convertStr(request.getParameter("ss"));
if(request.getParameter("xq")!=null) xq = jdbc.convertStr(request.getParameter("xq"));
if(request.getParameter("shdz")!=null) shdz = jdbc.convertStr(request.getParameter("shdz"));
if(request.getParameter("yzbm")!=null) yzbm = jdbc.convertStr(request.getParameter("yzbm"));
if(request.getParameter("sfdy")!=null) sfdy = jdbc.convertStr(request.getParameter("sfdy"));
if(request.getParameter("gxrq")!=null) gxrq = jdbc.convertStr(request.getParameter("gxrq"));
if(request.getParameter("gxr")!=null) gxr = jdbc.convertStr(request.getParameter("gxr"));
if(request.getParameter("cz")!=null) cz = jdbc.convertStr(request.getParameter("cz")); String sqladdid = "insert into WUSER_KEY values()";
String sqladd = "insert into WUSER (WUID,UZH,VIP_NO,NAME,HYJF,SEX,PASS,PAQU,PANSER,BIRTH,JOB,XL,SL,SFZH,E_MAIL,CYDH,GJ,SS,XQ,SHDZ,YZBM,SFDY,GXRQ,GXR,CZ)values(@@identity,'"+uzh+"','"+vip_no+"','"+name+"',"+hyjf+",'"+sex+"','"+pass+"','"+paqu+"','"+panser+"','"+birth+"','"+job+"','"+xl+"','"+sl+"','"+sfzh+"','"+email+"','"+cydh+"','"+gj+"','"+ss+"','"+xq+"','"+shdz+"','"+yzbm+"','"+sfdy+"' ,Getdate(),'','"+cz+"')";
//out.print(sqladd);
//out.close();
jdbc.startTransaction();
try{
jdbc.executeUpdate(sqladdid);
jdbc.executeUpdate(sqladd);
jdbc.commit();
flag = true;
}
catch(Exception e){
out.println("新增用户时发生异常:"+e.getMessage());
jdbc.rollback();
flag = false;
}
finally{
jdbc.stopTransaction();
}
if(flag){
//out.print("提交成功!"); response.sendRedirect("shangc_zc3.jsp?uzh="+uzh);
}
else{
//out.print("提交失败!");
response.sendRedirect("shangc_zc2.jsp");
}
%>
<%
jdbc.stopConnection();
%>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.text.*" %>
<%@ page import = "database.JDBC" %>
<%@ page contentType="text/html;charset=GB2312"%>
<jsp:useBean id="jdbc" scope="page" class="database.JDBC"/>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>申请网上商城用户</title>
<%
boolean flag = true;
int wuid = 0;
String vip_no ="" ;
int hyjf = 0;
String uzh = "";
String name = "";
String sex = "";
String pass = "";
String paqu = "";
String panser = "";
String birth = "";
String job = "";
String xl = "";
String sl = "";
String sfzh = "";
String email = "";
String cydh= "";
String gj = "";
String ss = "";
String xq = "";
String shdz = "";
String yzbm = "";
String sfdy = "";
String gxrq = "";
String gxr = "";
String cz="";
uzh=new String(request.getParameter("sc_name").getBytes("ISO8859_1"));
if(request.getParameter("vip_no")!=null) vip_no = jdbc.convertStr(request.getParameter("vip_no"));
//if(Integer.parseInt(request.getParameter("hyjf"))>0) vip_no = Integer.parseInt(request.getParameter("hyjf"));
// if(Integer.parseInt(request.getParameter("SEX"))>0) SEX = Integer.parseInt(request.getParameter("SEX"));
if(request.getParameter("name")!=null) name = jdbc.convertStr(request.getParameter("name"));
if(request.getParameter("sex")!=null) sex = jdbc.convertStr(request.getParameter("sex"));
if(request.getParameter("mima1")!=null) pass = jdbc.convertStr(request.getParameter("mima1"));
if(request.getParameter("paqu")!=null) paqu = jdbc.convertStr(request.getParameter("paqu"));
if(request.getParameter("panser")!=null) panser = jdbc.convertStr(request.getParameter("panser"));
if(request.getParameter("CSRQ")!=null) birth = jdbc.convertStr(request.getParameter("CSRQ"));
if(request.getParameter("job")!=null) job = jdbc.convertStr(request.getParameter("job"));
if(request.getParameter("xl")!=null) xl = jdbc.convertStr(request.getParameter("xl"));
if(request.getParameter("sl")!=null) sl = jdbc.convertStr(request.getParameter("sl"));
if(request.getParameter("sfzh")!=null) sfzh = jdbc.convertStr(request.getParameter("sfzh"));
if(request.getParameter("email")!=null) email = jdbc.convertStr(request.getParameter("email"));
if(request.getParameter("cydh")!=null) cydh = jdbc.convertStr(request.getParameter("cydh"));
if(request.getParameter("gj")!=null) gj = jdbc.convertStr(request.getParameter("gj"));
if(request.getParameter("ss")!=null) ss = jdbc.convertStr(request.getParameter("ss"));
if(request.getParameter("xq")!=null) xq = jdbc.convertStr(request.getParameter("xq"));
if(request.getParameter("shdz")!=null) shdz = jdbc.convertStr(request.getParameter("shdz"));
if(request.getParameter("yzbm")!=null) yzbm = jdbc.convertStr(request.getParameter("yzbm"));
if(request.getParameter("sfdy")!=null) sfdy = jdbc.convertStr(request.getParameter("sfdy"));
if(request.getParameter("gxrq")!=null) gxrq = jdbc.convertStr(request.getParameter("gxrq"));
if(request.getParameter("gxr")!=null) gxr = jdbc.convertStr(request.getParameter("gxr"));
if(request.getParameter("cz")!=null) cz = jdbc.convertStr(request.getParameter("cz")); String sqladdid = "insert into WUSER_KEY values()";
String sqladd = "insert into WUSER (WUID,UZH,VIP_NO,NAME,HYJF,SEX,PASS,PAQU,PANSER,BIRTH,JOB,XL,SL,SFZH,E_MAIL,CYDH,GJ,SS,XQ,SHDZ,YZBM,SFDY,GXRQ,GXR,CZ)values(@@identity,'"+uzh+"','"+vip_no+"','"+name+"',"+hyjf+",'"+sex+"','"+pass+"','"+paqu+"','"+panser+"','"+birth+"','"+job+"','"+xl+"','"+sl+"','"+sfzh+"','"+email+"','"+cydh+"','"+gj+"','"+ss+"','"+xq+"','"+shdz+"','"+yzbm+"','"+sfdy+"' ,Getdate(),'','"+cz+"')";
//out.print(sqladd);
//out.close();
jdbc.startTransaction();
try{
jdbc.executeUpdate(sqladdid);
jdbc.executeUpdate(sqladd);
jdbc.commit();
flag = true;
}
catch(Exception e){
out.println("新增用户时发生异常:"+e.getMessage());
jdbc.rollback();
flag = false;
}
finally{
jdbc.stopTransaction();
}
if(flag){
//out.print("提交成功!"); response.sendRedirect("shangc_zc3.jsp?uzh="+uzh);
}
else{
//out.print("提交失败!");
response.sendRedirect("shangc_zc2.jsp");
}
%>
<%
jdbc.stopConnection();
%>
解决方案 »
- myeclipse怎么运行jsp
- 请教:怎样去掉 分页显示 的当前页面上的超连接的下划线?其他的都有下划线!
- 郁闷中
- 在线等待...请问在JAVA中怎样将XML文件中数据更新到数据库表中?急!!!
- String s;问if(s==null) 与if(s=="")的区别
- 请进来看看:一个关于包的问题!!!
- 想要一个struts2和Spring的web开发项目作为我的毕业设计,请好心人帮忙
- Chrome浏览器怎样调用Office打开文档
- 怎样通过javascript指定下拉框的某一项为selected的?
- struts只能用在tomcat里吗
- 大家来看看这个网站www.by100.net 讨论一下
- 有安装过jive的嘛?
你能不能把这个完整的例子给我,谢谢了。
你有单独的用户注册的例子吗?
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="JavaScript" type="text/JavaScript">
function changepswd() {
if(form1.pass1.value!=form1.pass2.value) {
alert("密码两次输入不匹配!");
form1.pass1.value = "";
form1.pass2.value = "";
return false;
}
if(form1.pass1.value=="") {
alert("不能为空密码!");
return false;
}
if(form1.pass1.value.length>8) {
alert("密码必须少与8位");
form1.pass1.value = "";
form1.pass2.value = "";
return false;
}
form1.action = "addaction.jsp";
form1.submit();
}
</script>
</head><body>
<form name="form1" method="post" action="addaction.jsp" onSubmit="return valid()">
<p>
帐号: <input type="text" name="name">
</p>
<p>
密码: <input type="text" name="pass1">
</p>
<p>
确认密码:<input type="text" name="pass2">
</p>
<p> 性别:
<select name="sex">
<option value="0">男</option>
<option value="1">女</option>
</select>
</p>
<p>
<input type="button" name="Submit" value="确定提交" onClick="changepswd();">
</p>
</form>
</body>
</html>
<%@ page language="java" errorPage="" %>
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import = "java.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>添加注册</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<%
String name = "";
String pass = "";
int sex = 0 ; //0为男,1为女
String DBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String strConn = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyDatabase";
Connection conn = null;
if(request.getParameter("name")!=null) name = request.getParameter("name");
if(request.getParameter("pass1")!=null) pass = request.getParameter("pass1");
if(request.getParameter("sex")!=null) sex = request.getParameter("sex");
sql = "insert into user values("' + name + "','" + pass + "'," + sex + ")";
Class.forName(DBDriver);
conn = DriverManager.getConnection(strConn,"sa","");
Statement stmt = conn.createStatement();
int i = stmt.executeUpdate(sql);
if(i==0) out.print("添加失败");
rs.close();
conn.close();
%></body>
</html>数据库3个字段name(char),pass(char),sex(integer)
请把完整的例子发到我邮箱里吧(最好是能直接运行的,路径都部署好的),麻烦你了。
修改一下addaction.jsp(第二张网页)里面的strConn(database name,端口)就行了啊
请一并给出连数据库的类,谢谢。
《如何建立一个带登陆页面的Struts数据库应用程序》
《如何建立一个带登陆页面及角色的Struts数据库应用程序》
http://dev.csdn.net/user/kui
http://javaweb.51.net/
http://javawebStudio.51.net/
另外,下载《Struts开发实例》地址:
http://www.infoxa.com/asp/book/xxnr.asp?id=1333