实验感受:
本次实验最大的感受,就是不要改代码,自己写,代码改起来真的没完没了,不知道会出现什么问题。还有就是一定要清楚自己要怎么去写,流程很重要,一个个功能去实现。
主界面
数据库
主页面代码
request.setCharacterEncoding("UTF-8"); //设置响应的编码为UTF-8
response.setCharacterEncoding("UTF-8"); //设置响应的编码为UTF-8
%>
String path = request.getContextPath(); //相对Path设置
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; //相对Path设置
%>
库存物资信息录入
function validate()
{
var name = document.forms[0].name.value; //创建变量name
var factory = document.forms[0].factory.value; //创建变量teacher
var id = document.forms[0].id.value;
var standard = document.forms[0].standard.value; //创建变量address
if(name.length <= 0){ //判断姓名位数,必填
alert("名称不能为空,请输入名称!");
return false;
}
else if(factory.length <= 0){ //判断年龄,必填
alert("请输入合法生产工厂!");
return false;
}
else if(id.length <= 0){ //判断学号位数,必填
alert("型号不能为空,请输入型号!");
return false;
}
else if(standard.length <= 0){ //专业为必填
alert("规格不能为空,请输入商品规格!");
return false;
}
else{
return true;
}
//document.getElementById("form").submit();
}
库存商品信息录入
库存商品名称: |
生产工厂: |
型号: |
规格: |
request.setCharacterEncoding("UTF-8"); //设置响应的编码为UTF-8
response.setCharacterEncoding("UTF-8"); //设置响应的编码为UTF-8
%>
String path = request.getContextPath(); //相对Path设置
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; //相对Path设置
%>
库存商品信息删除界面request.setCharacterEncoding("UTF-8"); //设置响应的编码为UTF-8
String name = request.getParameter("name");
Connection conn = null; //定义静态数据库连接 //定义静态数据库连接
Statement stat = null;
ResultSet rs = null; //将rs滞空。
conn = DBUtil.getConnection();
stat = conn.createStatement();
stat.executeUpdate("delete from good where name = '" + name + "'"); //删除data表中的name字段
rs = stat.executeQuery("select * from good"); //查找data表
if(rs.next()) //判断结果集
{
out.print("
删除成功!
}
else{
out.print("
删除失败!
}
%>
if(rs != null)
{
rs.close(); //关闭结果集,但是rs还是有null值。
rs = null; //将rs滞空。
}
if(stat != null)
{
stat.close(); //关闭stat。
stat = null; //滞空stat。
}
if(conn != null)
{
conn.close(); //关闭数据库连接
conn = null;
}
%>
request.setCharacterEncoding("UTF-8"); //设置响应的编码为UTF-8
response.setCharacterEncoding("UTF-8"); //设置响应的编码为UTF-8
%>
String path = request.getContextPath(); //相对Path设置
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; //相对Path设置
%>
库存商品信息
function validate()
{
var name = document.forms[0].name.value;
var factory = document.forms[0].factory.value;
var id = document.forms[0].id.value;
var standard = document.forms[0].standard.value;
if(name.length <= 0){ //判断姓名位数,必填
alert("名称不能为空,请输入名称!");
return false;
}
else if(factory.length <= 0){ //判断年龄,必填
alert("请输入合法生产工厂!");
return false;
}
else if(id <= 0){ //判断学号位数,必填
alert("型号不能为空,请输入型号!");
return false;
}
else if(standard.length <= 0){ //专业为必填
alert("规格不能为空,请输入商品规格!");
return false;
}
else{
return true;
}
//document.getElementById("form").submit();
}
response.setCharacterEncoding("UTF-8"); //设置响应的编码为UTF-8
request.setCharacterEncoding("UTF-8"); //设置响应的编码为UTF-8
String name = request.getParameter("name");
String factory = request.getParameter("factory");
String id = request.getParameter("id");
String standard = request.getParameter("standard");
Connection conn = null; //定义静态数据库连接
Statement stat = null; //滞空stat。
ResultSet rs = null; //将rs滞空。
conn = DBUtil.getConnection();
stat = conn.createStatement();
rs = stat.executeQuery("select * from good where name='" + name + "'"); //查找data表id字段
%>
库存商品信息
要修改的库存商品信息如下
库存商品名称 | 库存商品生产工厂 | 库存商品型号 | 库存商品规格 |
while(rs.next())
{
out.print("
");out.print("
" + rs.getString("name") + ""); //输出name内容out.print("
" + rs.getString("factory") + ""); //输出gender内容out.print("
" + rs.getString("id") + "");out.print("
" + rs.getString("standard") + ""); //输出major内容out.print("
");%>
将库存商品信息更改为:
库存商品名称:" title="库存商品名称不能改变" onClick="return checkName(name)"readonly="readonly">
库存商品生产工厂:
库存商品型号:
库存商品规格:
}
%>
if(rs != null)
{
rs.close(); //关闭结果集,但是rs还是有null值。
rs = null; //将rs滞空。
}
if(stat != null)
{
stat.close(); //关闭stat。
stat = null; //滞空stat。
}
if(conn != null)
{
conn.close(); //关闭数据库连接
conn = null;
}
%>
request.setCharacterEncoding("UTF-8"); //设置响应的编码为UTF-8
response.setCharacterEncoding("UTF-8"); //设置响应的编码为UTF-8
%>
String path = request.getContextPath(); //相对Path设置
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; //相对Path设置
%>
修改界面
request.setCharacterEncoding("UTF-8"); //设置响应的编码为UTF-8
String name1 = request.getParameter("name");
String factory1 = request.getParameter("factory");
String id1 = request.getParameter("id");
String standard1 = request.getParameter("standard");
Connection conn = null; //定义静态数据库连接
Statement stat = null;
conn = DBUtil.getConnection();
stat = conn.createStatement();
stat.execute("update good set name='" + name1 + "' ,factory='" + factory1 + "' ,id='" + id1 + "' ,standard='" + standard1+"' where name='" + name1 + "'");
ResultSet rs = stat.executeQuery("select * from good where name='" + name1 + "'"); //查找data表id字段
%>
修改成功!
修改后的库存商品信息为:
库存商品名称 | 库存商品生产工厂 | 库存商品型号 | 库存商品规格 |
while(rs.next())
{
out.print("
");out.print("
" + rs.getString("name") + ""); //输出name内容out.print("
" + rs.getString("factory") + ""); //输出gender内容out.print("
" + rs.getString("id") + "");out.print("
" + rs.getString("standard") + ""); //输出major内容out.print("
");}
%>
if(rs != null)
{
rs.close(); //关闭结果集,但是rs还是有null值。
rs = null; //将rs滞空。
}
if(stat != null)
{
stat.close(); //关闭stat。
stat = null; //滞空stat。
}
if(conn != null)
{
conn.close(); //关闭数据库连接
conn = null;
}
%>
package com.javao.msg;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DBUtil {
public static Connection getConnection() {
try {
//1 鍔犺浇椹卞姩
Class.forName("com.mysql.cj.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String user = "root";
String password = "123456";
String url = "jdbc:mysql://localhost:3306/inventory?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false";
Connection connection = null;
try {
//2 鍒涘缓閾炬帴瀵硅薄connection
connection = DriverManager.getConnection(url,user,password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return connection;
}
//鍏抽棴璧勬簮鐨勬柟娉�
public static void close(Connection connection ) {
try {
if (connection != null) {
connection.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void close(PreparedStatement preparedStatement ) {
try {
if (preparedStatement != null) {
preparedStatement.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void close(ResultSet resultSet ) {
try {
if (resultSet != null) {
resultSet.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}