Servlet+JSP开发简单实例

1.数据库Oracle

2.代码
导JAR包：1.jsp-api.jar ; 2.jstl.jar ; 3.ojdbc6.jar ; 4.servlet-api.jar ; 5.standard.jar
​ 2.1实体类domain

package com.userinfos.domain;import java.util.Date;public class userinfos {private int userid;private String username;private Date birthday;public int getUserid() {return userid;}public void setUserid(int userid) {this.userid = userid;}public String getUsername() {return username;}public void setUsername(String username) {this.username = username;}public Date getBirthday() {return birthday;}public void setBirthday(Date birthday) {this.birthday = birthday;}}

2.2工具类tools

package com.userinfos.tools;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;public class DbUtil {private static final String DRIVER="oracle.jdbc.driver.OracleDriver";private static final String URL="jdbc:oracle:thin:@127.0.0.1:1521:orcl";private static final String USERNAME="yangjun";private static final String PASSWORD="yj";private static Connection conn;static{try {Class.forName(DRIVER);conn = DriverManager.getConnection(URL,USERNAME,PASSWORD);} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}private DbUtil(){};public static Connection getConnection(){return conn;}}

package com.userinfos.tools;import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;public class DbManager {private Connection conn;private PreparedStatement pstat;private ResultSet rs;public DbManager(){conn=DbUtil.getConnection();}public int update(String sql,Object[]params){int count =0;try {pstat=conn.prepareStatement(sql);for (int i = 0; i < params.length; i++) {pstat.setObject(i+1, params[i]);}count = pstat.executeUpdate();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return count;}public ResultSet query(String sql,Object[]params){try {pstat=conn.prepareStatement(sql);for (int i = 0; i < params.length; i++) {pstat.setObject(i+1, params[i]);}rs = pstat.executeQuery();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return rs;}
}

2.3 dao类

package com.userinfos.dao;import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.List;import com.userinfos.domain.Userinfos;
import com.userinfos.tools.DbManager;public class UserinfosDAO {private DbManager dbm;public UserinfosDAO(){dbm = new

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！