用servlet连接数据库

最新推荐文章于 2021-02-11 09:28:10 发布

闫梅

最新推荐文章于 2021-02-11 09:28:10 发布

阅读量2.9k

点赞数

分类专栏： Java Web

本文链接：https://blog.csdn.net/yantingmei/article/details/14107423

版权

本文介绍了如何通过servlet连接并操作MySQL数据库，包括User表的使用，详细讲解了User.java、DBConn.java、UserDaoImp.java、db.properties配置文件、web.xml设置以及login.html页面和UserServlet.java servlet的实现过程，最终展示了成功的运行结果。

摘要由CSDN通过智能技术生成

user数据库表

读取数据库信息User.java

package user.domain;

import java.io.Serializable;
import java.util.Date;

public class User implements Serializable{

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
    
	private Integer id;
	private String name;
	private String pass;
	private Date birth;
	public User(){
		super();
	}
	public User(Integer id, String name, String pass, Date birth) {
		super();
		this.id = id;
		this.name = name;
		this.pass = pass;
		this.birth = birth;
	}
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPass() {
		return pass;
	}
	public void setPass(String pass) {
		this.pass = pass;
	}
	public Date getBirth() {
		return birth;
	}
	public void setBirth(Date birth) {
		this.birth = birth;
	}
	@Override
	public String toString() {
		return "User [id=" + id + ", name=" + name + ", pass=" + pass
				+ ", birth=" + birth + "]";
	}
	
}

用servlet对数据库进行增删查改

package user.dao;

import java.util.List;

import user.domain.User;

public interface UserDao {
    /**
     * 查询所以 
     */
	List<User> findAll();
	  /**
     * 根据id查询 
     */
	User findById(Integer id);
	  /**
     * 根据id删除实体对象 
     */
	void deleteById(Integer id) throws Exception;
	/**
	 * 删除实体对象
	 */
	void delete(User entity) throws Exception;
	/**
	 * 更新实体
	 */
	void update(User entity) throws Exception;
	/**
	 * 插入实体
	 */
	void insert(User entity) throws Exception;
	/**
	 * 根据用户和密码查询用户信息
	 */
	User checkLogin(String name,String pass);
	
}

工具包DBConn.java

package util;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

public class DBConn {
 private static Connection conn;
 private DBConn(){
	 
 }
 public static Connection getConn(){
	 if(conn==null){
		 //创建集合对象
		 Properties properties=new Properties();
		 try {
			 //装载
			properties.load(DBConn.class.getClassLoader().getResourceAsStream("db.properties"));
		    //加载驱动程序
			Class.forName(properties.getProperty("driverClassName"));
			//获取连接对象
			conn=DriverManager.getConnection(properties.getProperty("url"),properties.getProperty("user"),properties.getProperty("pass"));
		 } catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	 }
	 return conn;
 }
 public static void update(String sql,Object params[],PreparedStatement pstmt) throws Exception{
	 pstmt=getConn().prepareStatement(sql);
	 for (int i = 0; i < params.length; i++) {
		pstmt.setObject(i+1, params[i]);
	}
	 pstmt.executeUpdate();
	 release(null,pstmt);
 }
public  static void release(ResultSet rs, PreparedStatement pstmt) {
     if (rs!=null) {
		try {
			rs.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();