我的效果图:
首页
添加
查询
修改
代码摘要:
index.jsp
<%@ page language="java" contentType="text/html;
charset=UTF-8"
pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=UTF-8">
<title>首页</title>
<style>
.content{
margin:auto;
width:70%;
font-family:"Microsoft YaHei";
font-size:16px;
}
table,table tr
th,table tr td{
border:2px solid #000;
padding:4px 15px;
}
table tr th{
background:#f0f0f0;
}
table {
min-height: 30px;
line-height: 30px;
text-align: center;
border-collapse: collapse;
}
img{
margin:6px;
}
.btn1,.btn2{
width:60px;
height:30px;
font-size:16px;
margin:6px;
border-radius:4px;
}
.btn1{
background:#fff;
color:#3366ff;
border:2px solid #3366ff;
}
.btn1:hover{
background:#3366ff;
color:#fff;
}
.btn2{
background:#fff;
color:ff9999;
border:2px solid #ff9999;
}
.btn2:hover{
background:#ff9999;
color:#fff;
}
</style>
</head>
<body>
<div class="content">
<div class="header">
<input type="button"
name="add" class="btn1"
value="增加" onclick="window.open('add.jsp','_self')"/>
<input type="button"
name="select" class="btn2"
value="查询" onclick="window.open('select.jsp','_self')"/>
</div>
<table border=1 >
<tr>
<th>序号</th>
<th>会员编号</th>
<th>会员姓名</th>
<th>性别</th>
<th>操作</th>
</tr>
<%
try{
Class.forName("com.mysql.jdbc.Driver");//记载数据库驱动,注册到驱动管理器
String url="jdbc:mysql://localhost:3306/td_customersinfo?characterEncoding=utf8";
String username="root";
String password="123456";
Connection
conn=DriverManager.getConnection(url,username,password);
if(conn!=null){
Statement
stmt=conn.createStatement();//实例化Statement对象
String queryNumberSQL= "select
Tci_idno,Tci_courtid,Tci_name,Tci_gender from td_customersinfo";
ResultSet rs=stmt.executeQuery(queryNumberSQL);
%>
<%
while (rs.next()) {
%>
<tr>
<td>
<%
String idno = rs.getString(1);
out.print(rs.getString(1));
%>
</td>
<td>
<%
out.print(rs.getString(2));
%>
</td>
<td>
<%
out.print(rs.getString(3));
%>
</td>
<td>
<% if(rs.getString(4).equals("1")){
out.print("男");
}else{
out.print("女");
}
%>
</td>
<td>
<img alt="修改" src="image/edit2.png"
width=25 height=25 onclick="window.open('edit.jsp?idno='+<%=idno%>,'_self');"/>
<img alt="删除" src="image/delete1.jpg"
width=25 height=25 onclick="window.open('delete.jsp?idno='+<%=idno%>,'_self')"/>
</td>
</tr>
<%}
}else{
out.println("数据库连接失败!!!");
}
}catch(ClassNotFoundException e){
e.printStackTrace();
}
%>
</table>
</div>
</body>
</html>
- 将mysql-connector-jar 导入web-inf 下的 lib 目录
- <%@page import=“java.sql.*”%>
- 数据库连接,可以写在 body 里
<%
try{
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/databasename?characterEncoding=utf8";
String usename = "root";
String usepassword ="123456";
Connection conn = DriverManager.getConnection(url,usename , usepassword);
sql 语句代码
conn.close();
}else{
out.println("数据库连接失败!!!");
}
}catch(ClassNotFoundException e){
e.printStackTrace();
}
%>
- 基本语句
- insert/update/delete
String sql1= "delete from tablename where xxx= ?";
String sql2 = "insert into tablename(xxx,xxx) values(?,?)";
String sql3 = "update tablename set xxx=?,xxx=? where xxx=?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, "xxx");
ps.executeUpdate();
- select
Statement stmt=conn.createStatement();//实例化Statement对象
String queryNumberSQL= "select * from tablename where xxx=x";
ResultSet rs=stmt.executeQuery(queryNumberSQL);
while(rs.next()){
out.print(rs.getString(1));
out.print(rs.getString(2));
out.print(rs.getString(3));
}
温故知新~
-
中文乱码
获取表单数据时使用
request.setCharacterEncoding(“utf-8”);
连接数据库时使用
String url = “jdbc:mysql://localhost:3306/datebasename?characterEncoding=utf8”;
将ecplise 和 mysql 均设置为 utf-8 -
增删改查操作后更新页面
用户界面
<input type="button" name="add" value="增加" onclick="window.open('add.jsp','_self')"/>
操作页
response.sendRedirect("index.jsp");
- 设置主键不可修改
<input type="text" name="id" value="<%=rs.getString(1)%>" readonly>
如果提交表单 注意不要使用 disabled ,使用readonly 较合适
ok,bye~