jdbc连接获取数据库步骤

首先是创建的Mysql数据库表 student： jdbc连接获取数据库步骤

jdbc连接获取数据库步骤

设置保存信息的界面用来获取mysql里的数据，将其存储在集合中，在下一个页面遍历出来：

jdbc连接获取数据库步骤

<%@page import="com.baidu.jdbc.util.ConfigUtil"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.*"%>

<%@ page import = "com.baidu.jdbc.student.*" %>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
//加载驱动
Class.forName(ConfigUtil.getValue("driver"));//类全名（类名加包名）
//创建数据库连接
Connection conn = DriverManager.getConnection(ConfigUtil.getValue("url"), ConfigUtil.getValue("username"), ConfigUtil.getValue("password"));
//操作数据库
Statement st = conn.createStatement();
//执行Query操作
//编写sql
String sql = "select * from student";
ResultSet rs = st.executeQuery(sql);
//得到返回值
//创建存储学生信息的集合
List<Student> stus = new ArrayList<Student>();
while(rs.next()){
String stuNo = rs.getString("Sname");//或者rs.getString(1),数字为列数
String sex = rs.getString("Ssex");
String s = rs.getString("S");
//给Student赋值
Student stu = new Student ();

stu.setSname(stuNo);
stu.setSsex(sex);
stu.setS(s);

//添加到stus 的集合中
stus.add(stu);
}
//释放资源，先判断是否空，关闭对象

if(rs != null){
rs.close();}
if(st != null)st.close();
if(conn != null)conn.close();
//将stuList存储到request对象中
request.setAttribute("list", stus);
//跳转到stulist.jsp中
request.getRequestDispatcher("stulist.jsp").forward(request, response);

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import = "com.baidu.jdbc.student.*" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

以下是跳转的JSP页面
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>学生列表</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">


</head>

<body>
<%
List<Student> stus = (List<Student>)request.getAttribute("list");

%>
<a href = "page/addStu.jsp">登记学生信息</a>
<table width="100%" border="1px">

<tr>
<th>姓名</th>
<th>性别</th>
<th>编号</th>
<th>操作</th>

</tr>
<%
if(stus !=null && stus.size() >0){
for(Student stu : stus){
%>
<tr>
<td><%=stu.getSname() %></td>
<td><%=stu.getSsex() %></td>
<td><%=stu.getS() %></td>
<td><a href="#">修改</a> | <a href="#">删除</a></td>
</tr>
<% }
}else{ %>
<tr>
<td colspan="4" align="center">暂无数据！</td>

</tr>
<% }%>
</table>
</body>

</html>

之后跳转到登记学员信息:

jdbc连接获取数据库步骤

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>登记学员信息</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">


</head >

<body>
<form action="page/doSave.jsp" method = "post" >
<table border = "1px" align='center' >
<tr>
<td>编号:</td>
<td><input type = "text" name = "stuNo"></td>
</tr>
<tr>
<td>姓名:</td>
<td ><input type = "text" name = "stuName" ></td>
</tr>

<tr>
<td>性别:</td>
<td>
<input type = "radio" name = "gender" value = 男>女
<input type = "radio" name = "gender" value = 女>男
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" value = "保存" />
<input type="button" value = "返回" />
</td>

</tr>
</table>

</form>
</body>

</html>

设置保存jsp：

<%@page import="java.sql.*"%>

<%@page import="com.baidu.jdbc.util.ConfigUtil"%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");

//加载驱动
Class.forName(ConfigUtil.getValue("driver"));
//获取前端的输入值
String stuNo = request.getParameter("stuNo");
String stuName = request.getParameter("stuName");
String gender = request.getParameter("gender");

//获取连接
String url = ConfigUtil.getValue("url");
String uname = ConfigUtil.getValue("username");
String pwd = ConfigUtil.getValue("password");
DriverManager.getConnection(url,uname,pwd);
Connection conn = DriverManager.getConnection(url,uname,pwd);
//执行执行操作
String sql = "insert into student(S,Sname,Ssex) values(?,?,?)";
PreparedStatement ps = conn.prepareStatement(sql);
int ss=0;
if(stuNo != null && !"".equals(stuNo)){
ss = Integer.parseInt(stuNo);
}
ps.setInt(1,ss);
ps.setString(2,stuName);
ps.setString(3,gender);
//执行命令
int result = ps.executeUpdate();
if(result>0){
request.getRequestDispatcher("doList.jsp").forward(request, response);
System.out.println("保存成功");

}else{
request.getRequestDispatcher("addStu.jsp").forward(request, response);
System.out.println("保存失败");

}
//释放资源
if(ps != null) ps.close();
if(conn != null) conn.close();

%>

jdbc连接获取数据库步骤

相关推荐