jsp操作mysql数据库项目实例下载,简单的jsp项目下载。增添删除查找数据库的应用代码介绍。servlet应用。
创建数据表的sql语句:
CREATE TABLE users (
id int(11) NOT NULL,
name varchar(20) DEFAULT NULL,
age int(11) DEFAULT NULL,
tel varchar(20) DEFAULT NULL,
address varchar(50) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
连接数据库的java类:
package com.cn.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBC_Connection {
static String drivername =”com.mysql.jdbc.Driver”;//mysql数据库驱动
static String url=”jdbc:mysql://localhost:3306/bank”;//连接的数据库地址
static String username=”root”;//连接数据库用户名
static String password=”root”;//连接数据库密码
//创建驱动的静态代码块
static{
try {
Class.forName(drivername);//创建驱动
System.out.println(“创建驱动成功!”);
} catch (ClassNotFoundException e) {
System.out.println(“创建驱动失败!请检查驱动!”);
e.printStackTrace();
}
}
/**
* 连接数据库的方法
* @return
*/
public static Connection getConnection(){
Connection conn = null;
try {
conn = (Connection) DriverManager.getConnection(url, username, password);//创建连接
System.out.println(“连接数据库成功!”);
} catch (SQLException e) {
System.out.println(“连接数据库失败!请检查url、username或者password”);
e.printStackTrace();
}
return conn;
}
/**
* 该方法用于关闭结果集、连接和Statement对象。
* @param rs
* @param conn
* @param stmt
*/
public static void free(ResultSet rs,Connection conn ,Statement stmt){
try {
if(rs !=null)
rs.close();//关闭结果集
} catch (SQLException e) {
System.out.println(“关闭ResultSet失败!”);
e.printStackTrace();
}finally {
try {
if(conn != null)
conn.close();//关闭连接
} catch (SQLException e) {
System.out.println(“关闭Connection失败!”);
e.printStackTrace();
}finally{
try {
if(stmt != null)
stmt.close();//关闭Statement对象
} catch (SQLException e) {
System.out.println(“关闭Statement失败!”);
e.printStackTrace();
}
}
}
}
public static void main(String[] args) {
//调用该类的getConnection方法,测试连接是否成功
JDBC_Connection.getConnection();
}
}
增添数据信息的java,AddUser.java文件:
package com.cn.add;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import com.cn.jdbc.JDBC_Connection;
import com.cn.vo.UserVo;
public class AddUser {
public void add(UserVo userVo){
Connection conn = null;
PreparedStatement pstm = null;
ResultSet rs = null;
try {
//调用JDBC_Connection类的getConnection方法连接数据库
conn = JDBC_Connection.getConnection();
//添加数据的sql语句
String sql = “insert into users(id,name,age,tel,address) values(?,?,?,?,?)”;
pstm = conn.prepareStatement(sql);
pstm.setInt(1, userVo.getId());//把添加的id值存入pstm对象中,int类型的值用setInt()方法
//把添加的name值存入pstm对象中String类型的值用setString方法
pstm.setString(2,userVo.getName());
pstm.setInt(3,userVo.getAge());//把添加的age值存入pstm对象中
pstm.setString(4, userVo.getTel());//把添加的tel值存入pstm对象中
pstm.setString(5, userVo.getAddress());//把添加的address值存入pstm对象中
pstm.executeUpdate();//提交pstm对象
System.out.println(“添加成功!添加的内容如下:”);
System.out.println(“id:”+userVo.getId()+”\t name:”+userVo.getName()
+”\t age:”+userVo.getAge()+”\t tel:”+userVo.getTel()+
“\t address:”+userVo.getAddress());
} catch (Exception e) {
e.printStackTrace();
} finally {
JDBC_Connection.free(rs, conn, pstm);
}
}
}
增加用户实例的servlet,AddUsersServlet.java源码:
package com.cn.add;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.cn.vo.UserVo;
public class AddUsersServlet extends HttpServlet {
public void destroy() {
super.destroy(); // Just puts “destroy” string in log
// Put your code here
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType(“text/html”);
request.setCharacterEncoding(“gb2312″);//指定request的编码方式
response.setCharacterEncoding(“gb2312″);//指定response的编码方式
PrintWriter out = response.getWriter();
int id =Integer.parseInt(request.getParameter(“id”));//获得页面传递过来的id
String name = request.getParameter(“name”);//获得页面传递过来的name
int age = Integer.parseInt(request.getParameter(“age”));//获得页面传递过来的age
String tel = request.getParameter(“tel”);//获得页面传递过来的tel
String address = request.getParameter(“address”);//获得页面传递过来的address
//声明一个UserVo对象,把获得的参数放入该对象中
UserVo userVo = new UserVo();
userVo.setId(id);
userVo.setName(name);
userVo.setAge(age);
userVo.setTel(tel);
userVo.setAddress(address);
AddUser addUser = new AddUser();//声明一个AddUser对象
addUser.add(userVo);//调用AddUser对象中的add()方法
request.getRequestDispatcher(“addUsers.jsp”).forward(request, response);//转发到指定的页面
out.flush();
out.close();
}
public void init() throws ServletException {
// Put your code here
}
}
DeleteUser.java删除用户:
package com.cn.delete;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import com.cn.jdbc.JDBC_Connection;
public class DeleteUser {
public void deleteUser(int id) {
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn =JDBC_Connection.getConnection();
String sql = “delete from users where id =?”;
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, id);//给sql语句里的id赋值
pstmt.executeUpdate();
System.out.println(“删除成功!”);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
JDBC_Connection.free(null, conn, pstmt);//关闭连接
}
}
public static void main(String[] args) {
DeleteUser deleteUser = new DeleteUser();
int id = 001;
deleteUser.deleteUser(id);
}
}
添加用户的jsp文件addUsers.jsp:
-//W3C//DTD HTML 4.01 Transitional//EN”>
My JSP ‘addUsers.jsp’ starting page添加用户界面
编号: | |
姓名: | |
年龄: | |
电话: | |
地址: |
updateUser.jsp更新数据库信息:
-//W3C//DTD HTML 4.01 Transitional//EN”>
My JSP ‘updateUser.jsp’ starting page编号: | |
姓名: | |
年龄: | |
电话: | |
地址: |
以上是jsp操作mysql数据库的项目的部分代码,具体的你可以点击以下的链接下载: