textservlet.java
import java.io.IOException;
import java.sql.SQLException;
@javax.servlet.annotation.WebServlet("/TestServlet")
public class TestServlet extends javax.servlet.http.HttpServlet {
protected void doPost(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) throws javax.servlet.ServletException, IOException {
jdbc jdbc = new jdbc();
String s = "aaa";
try {
s = jdbc.jdbc2();
} catch (SQLException e) {
e.printStackTrace();
}
response.getWriter().write(s);
}
protected void doGet(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) throws javax.servlet.ServletException, IOException {
doPost(request,response);
}
}
zhuce.jsp
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.PreparedStatement" %><%--
Created by IntelliJ IDEA.
User: Administrator
Date: 2019/5/30 0030
Time: 下午 6:00
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<%
//1.注册
String username = request.getParameter("username");
String password = request.getParameter("password");
//2.连接数据库
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql:///stuinfo","root","123456");
String sql = "insert into stu values(?,?,?)";
PreparedStatement st = con.prepareStatement(sql);
st.setInt(1,4);
st.setString(2,username);
st.setString(3,password);
st.executeUpdate();
System.out.println("成功");
%>
</body>
</html>
index.jsp
<%--
Created by IntelliJ IDEA.
User: Administrator
Date: 2019/5/29 0029
Time: 上午 11:01
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>$Title$</title>
</head>
<form action = "zhuce.jsp" method="get" >
<body>
<from>
<table>
<tr>
<td>
用户名
</td>
<td><input type = "text" name = "username"></td>
</tr>
<tr>
<td>密码</td>
<td><input type = "password" name = "password"></td>
</tr>
<tr>
<input type = "submit" value ="注册">
</tr>
</table>
</from>
</body>
</form>
</html>
jdbc.java
import com.mysql.jdbc.Driver;
import java.sql.*;
public class jdbc {
public String jdbc2() throws SQLException {
//1.注册驱动,加载到内存;
DriverManager.registerDriver(new Driver());
//
//2.获取连接对象;
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/stuinfo","root","123456");
// Connection con = DriverManager.getConnection("jdbc:mysql:///stuinfo","root","123456");
//3.通过连接对象获取操作sql语句的statment对象
Statement st = con.createStatement();
//4.执行sql语句
String sql = "select * from stuinfo";
//String sql = "update stuinfo set age = 29 where id = 1 ";
ResultSet rs = st.executeQuery(sql);
//5.通过遍历获取表中每条记录
// while(rs.next()){
rs.next();
int id = rs.getInt("id");
String name = rs.getString(1);
int age = rs.getInt(3);
System.out.println(id+"..."+name+"..."+age);
//}
return id+"..."+name+"..."+age;
}
}
jjbd.java
import java.sql.*;
public class jjdb {
public static void main(String args[]){
Connection con = null;
Statement st = null;
ResultSet rs = null;
try {
//使用反射;
Class.forName("com.mysql.jdb.Driver");
con =(Connection) DriverManager.getConnection("jdbc:mysql:///stuinfo","root","123456");
st = con.createStatement();
String sql = "select * from stuinfo";
rs = st.executeQuery(sql);
st = con.createStatement();
while(rs.next()){
int id = rs.getInt(1);
String name = rs.getString(1);
int age = rs.getInt(3);
System.out.println(id+"..."+name+"..."+age);
}
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}finally {
try {
if(rs!=null)
rs.close();
}catch (SQLException e){
e.printStackTrace();
}
try{
if(st!=null)
st.close();
}catch(SQLException e)
{
e.printStackTrace();
}
}
}
}