面试机试当场用jsp+servlet写一个学生注册系统，将那个servlet附下分享
日期：2014-05-16 浏览次数：20326 次
面试机试当场用jsp+servlet写一个学生注册系统，将那个servlet附上分享
package com.ht.servlet;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Detail extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = 1L;
private static String url = "jdbc:oracle:thin:@localhost:1521:orcl";
private static String username = "liumei";
private static String password = "liumei";
public static Connection conn;
public ResultSet select(String str){
ResultSet rs = null;
Class.forName("oracle.jdbc.driver.OracleDriver");
// 第三步：创建数据库连接对象
conn = DriverManager.getConnection(url, username,
password);
Statement statement = conn.createStatement();
rs = statement.executeQuery(str);
} catch (Exception e) {
e.printStackTrace();
}
return rs;
}
public List<StuTest> getBySno(String sno){
Detail detail = new Detail();
List<StuTest> list = null;
try {
ResultSet rs = detail
.select("select * from StuTest where StuTest.sno = '"
+ sno + "'");
if (rs.next()) {
list = new ArrayList<StuTest>();
do {
StuTest stutest = new StuTest();
stutest.setSno(rs.getString("sno"));
stutest.setName(rs.getString("name"));
stutest.setSex(rs.getString("sex"));
stutest.setCall(rs.getString("call"));
stutest.setPro(rs.getString("pro"));
list.add(stutest);
} while (rs.next());
}else{
return null;
package com.ht.servlet;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Detail extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = 1L;
private static String url = "jdbc:oracle:thin:@localhost:1521:orcl";
private static String username = "liumei";
private static String password = "liumei";
public static Connection conn;
public ResultSet select(String str){
ResultSet rs = null;
try {
//第一步：在开发环境中加载驱动程序（向lib中添加ojdbc6.jar）
Class.forName("oracle.jdbc.driver.OracleDriver");
// 第三步：创建数据库连接对象
conn = DriverManager.getConnection(url, username,
password);
Statement statement = conn.createStatement();
rs = statement.executeQuery(str);
} catch (Exception e) {
e.printStackTrace();
}
return rs;
}
public List<StuTest> getBySno(String sno){
Detail detail = new Detail();
List<StuTest> list = null;
try {
ResultSet rs = detail
.select("select * from StuTest where StuTest.sno = '"
+ sno + "'");
if (rs.next()) {
list = new ArrayList<StuTest>();
do {
StuTest stutest = new StuTest();
stutest.setSno(rs.getString("sno"));
stutest.setName(rs.getString("name"));
stutest.setSex(rs.getString("sex"));
stutest.setCall(rs.getString("call"));
stutest.setPro(rs.getString("pro"));
list.add(stutest);
} while (rs.next());
}else{
return null;
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
