📄 add.jsp
字号:
<!--add.jsp->
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<html>
<head>
<title>向数据库插入数据</title>
</head>
<body>
<%@ include file="format.jsp"%>
<%
Connection conn=null;
try{
int employeeID=Integer.parseInt(request.getParameter("employeeID"));
String employeeName=Bytes(request.getParameter("employeeName"));
String employeePost=Bytes(request.getParameter("employeePost"));
String employeeDept=Bytes(request.getParameter("employeeDept"));
float employeeWage=Float.parseFloat(request.getParameter("employeeWage"));
String sql="insert into employee
values("+employeeID+",'"+employeeName+"','"+employeePost+
"','"+employeeDept+"',"+ employeeWage+")";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:saloryDSN";
String user = "admin";
String password = "";
conn = DriverManager.getConnection(url, user, password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
stmt.executeUpdate(sql);
sql="select employee.* from employee";
ResultSet rs = stmt.executeQuery(sql); %>
<table border="6" align="center">
<tr bgcolor="d1d1ff">
<th>员工编号</th>
<th>员工姓名</th>
<th>员工职务</th>
<th>所属部门</th>
<th>基本工资</th>
</tr>
<%while(rs.next()){%>
<tr bgcolor="lightblue">
<td><%= rs.getString(1) %> </td>
<td><%= rs.getString(2) %> </td>
<td><%= rs.getString(3) %> </td>
<td><%= rs.getString(4) %> </td>
<td><%= rs.getString(5) %> </td>
</tr>
<%}
rs.close();
stmt.close();
conn.close();
}
catch(Exception ex){
}
%>
</TABLE>
</body>
</html>
但要想将包含中文的字符串添加到数据库中，还需添加如下的代码：
<!--format.jsp-->
<%!
public String Bytes(String str)
{
try
{
String str_1=str;
byte[] str_2=str_1.getBytes("ISO8859-1");
String bytes=new String(str_2);
return bytes;
}
catch(Exception e)
{
System.out.println("中文乱码解决问题出错"+e.getMessage());
}
return "null";
}
//自定义的一个函数，用来格式化表单参数的乱码，include该文件，执行:strname=Bytes(要格式话的string);
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -