1. mysql
create database oa;
use oa;
create table employee(
id int primary key auto_increment,
name varchar(20),
sex varchar(2),
age int,
address varchar(50)
);
insert into employee values(null,'張冰','女',23,'河南南洋');
insert into employee values(null,'王冰','女',23,'北京');
insert into employee values(null,'張風','男',23,'河南南');
insert into employee values(null,'李洋','女',33,'河南南');
2.insert.html
<html>
<body>
<center>
<form action="doinsert.jsp" method="post">
username:<input type="text" name="username"><br>
sex:<input type="text" name="sex"><br>
age:<input type="text" name="age"><br>
address:<input type="text" name="address"><br>
<input type="submit" value=" submit ">
</form>
</body>
</html>
3.doinsert.jsp
<%@ page contentType="text/html;charset=gbk" import="java.sql.*"%>
<html>
<body>
<font size="20">
<%
Connection con = null;
PreparedStatement stmt = null;//使用預編語句聲明
String sql = "";
String name=request.getParameter("username");
name = new String(name.getBytes("iso-8859-1"),"gbk");
String sex=request.getParameter("sex");
sex = new String(sex.getBytes("iso-8859-1"),"gbk");
String age=request.getParameter("age");
String address=request.getParameter("address");
address = new String(address.getBytes("iso-8859-1"),"gbk");
sql = "insert into employee(name,sex,age,address) values(?,?,?,?)";//使用通配符？賦值占位
try{
Class.forName("com.mysql.jdbc.Driver");//加載驅動
con= DriverManager.getConnection("jdbc:mysql://localhost:3306/oa","root","yu");//獲得連接
stmt=con.prepareStatement(sql);//由于prepareStatement不用解釋，安全，快速
stmt.setString(1,name);//與通配符？一一對應，并給通配符賦值
stmt.setString(2,sex);
stmt.setInt(3,Integer.parseInt(age));//將字符串轉化為int類型
stmt.setString(4,address);
stmt.executeUpdate();
out.print("插入成功");
}catch(Exception e){e.printStackTrace();}
%>
<br>
<a href="test.jsp">查看</a>
</font>
</body>
</html>
4.test.jsp
<%@ page contentType="text/html;charset=gbk" import="java.sql.*"%>
<html>
<body>
<font size="20">
<%
Connection con = null;
//Statement stmt = null;
PreparedStatement stmt = null;
ResultSet rs = null;
String sql = "";
sql = "select * from employee";
try{
Class.forName("com.mysql.jdbc.Driver");
con= DriverManager.getConnection("jdbc:mysql://localhost:3306/oa","root","yu");
//stmt = con.createStatement();
stmt=con.prepareStatement(sql);//直接對sql語句進行處理，不必解釋
//rs =stmt.executeQuery(sql);
rs =stmt.executeQuery();
while(rs.next())
{
out.print(rs.getString("name")+" "+rs.getString("sex")+" "+rs.getString("age")+" "+rs.getString("address")+"<br>");
}
}catch(Exception e){e.printStackTrace();}
%>
</font>
</body>
</html>
posted on 2009-04-21 11:21
鵬凌 閱讀(532)
評論(0) 編輯 收藏