新手问题.后台数据库不同,jsp里操作数据库的语句会不同么? 就是用不同数据库系统,对数据库操作的bean的语句也一样么?除了连接数据库那个bean 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 按照道理说,如果分层分的好的话,应该不需要修改jsp的代码。需要修改的,仅仅是针对数据库的操作那段,也就是d层的代码,数据库连接,释放,更新,插入。这些语句而已。 import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.pp.control.Action;public class Stu_manager extends Action{ public void execute(HttpServletRequest request, HttpServletResponse response) { String method=request.getParameter("stuadd"); Db_stu db_stu = null; if(method.equals("stuadd")){ try{ System.out.println("8"); db_stu = new Db_stu(); String stuname=request.getParameter("stuname"); String stucode=request.getParameter("stucode"); String stuphone=request.getParameter("stuphone"); String deparment=request.getParameter("deparment"); String username=request.getParameter("username"); String psw=request.getParameter("psw"); String type=request.getParameter("type"); Stu stu=new Stu(); stu.setStuname(stuname); stu.setStucode(stucode); stu.setDeparment(deparment); stu.setStuphone(stuphone); stu.setType(type); stu.setUsername(username); stu.setPsw(psw); db_stu.addstu(stu);//DB DO request.getRequestDispatcher("./success.jsp").forward(request,response); } catch (Exception e) { e.printStackTrace(); } }我是从jsp页面通过servlet调用这个javabean来添加用户package com.pp.admin;import java.io.IOException;import java.io.PrintWriter;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;import java.util.Collection;import javax.security.sasl.SaslException;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.pp.control.Action;import com.pp.control.common.DataBase;public class Db_stu { //创建公用数据库连接类对象 DataBase sourse=new DataBase(); Statement sm = null; //添加注册用户 public int addstu(Stu stu) { System.out.println("8"); sourse.getConnection(); try { String sql = "insert into stu(id,stuname,stucode," + "stuphone,classcode,username,psw,type) values('"+ stu.getId() + "','" + stu.getStucode() + "','" + stu.getStuname() + "','" + stu.getDeparment()+ "','" + stu.getStuphone() + "','" + stu.getUsername()+"','" + stu.getPsw() + "','" + stu.getType()+"')"; sql = new String(sql.getBytes("ISO8859-1"), "GB2312"); int i = sm.executeUpdate(sql); // 执行sql语句 return i; } catch (SQLException SqlE) { SqlE.printStackTrace(); return -1; } catch (Exception E) { E.printStackTrace(); return -2; } finally { // 关闭连接,释放数据库资源: sourse.close(); } } }到底对不对呢?还有个bean是封装了用户信息的 请前辈给介绍几本学习S2SH JQUARY的书,以及学习方法,谢谢。 如何停止一个请求 如何防止浏览器右键返回问题? 想在网页中加入一段代码实现显IP功能,如何做呢? js + mysql+javabean从数据库里添加js树型菜单 外网访问resin send reques 如何传递form的参数 最好的JSP的运行环境是什么?(送100分) 聊天室问题 什么是cach分页?讲讲方法,给个例子!谢谢! SERVLET中将已存在于服务器上BS系统下的一个文件存入mssql库中一个表里 开发JSP将access转MSSQL问题
import javax.servlet.http.HttpServletResponse;import com.pp.control.Action;public class Stu_manager extends Action{
public void execute(HttpServletRequest request, HttpServletResponse response) {
String method=request.getParameter("stuadd");
Db_stu db_stu = null;
if(method.equals("stuadd")){
try{
System.out.println("8");
db_stu = new Db_stu();
String stuname=request.getParameter("stuname");
String stucode=request.getParameter("stucode");
String stuphone=request.getParameter("stuphone");
String deparment=request.getParameter("deparment");
String username=request.getParameter("username");
String psw=request.getParameter("psw");
String type=request.getParameter("type");
Stu stu=new Stu();
stu.setStuname(stuname);
stu.setStucode(stucode);
stu.setDeparment(deparment);
stu.setStuphone(stuphone);
stu.setType(type);
stu.setUsername(username);
stu.setPsw(psw);
db_stu.addstu(stu);//DB DO
request.getRequestDispatcher("./success.jsp").forward(request,response);
}
catch (Exception e) {
e.printStackTrace();
}
}我是从jsp页面通过servlet调用这个javabean来添加用户package com.pp.admin;import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collection;
import javax.security.sasl.SaslException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import com.pp.control.Action;
import com.pp.control.common.DataBase;public class Db_stu {
//创建公用数据库连接类对象
DataBase sourse=new DataBase();
Statement sm = null;
//添加注册用户
public int addstu(Stu stu) {
System.out.println("8");
sourse.getConnection();
try {
String sql = "insert into stu(id,stuname,stucode," +
"stuphone,classcode,username,psw,type) values('"+ stu.getId()
+ "','" + stu.getStucode() + "','" + stu.getStuname()
+ "','" + stu.getDeparment()+ "','" + stu.getStuphone()
+ "','" + stu.getUsername()+"','" + stu.getPsw()
+ "','" + stu.getType()+"')";
sql = new String(sql.getBytes("ISO8859-1"), "GB2312");
int i = sm.executeUpdate(sql); // 执行sql语句
return i;
}
catch (SQLException SqlE) {
SqlE.printStackTrace();
return -1;
}
catch (Exception E) {
E.printStackTrace();
return -2;
}
finally {
// 关闭连接,释放数据库资源:
sourse.close();
}
}
}到底对不对呢?还有个bean是封装了用户信息的