该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
1:
package com.demo;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import oracle.demo3;
public class demo2 extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String username = request.getParameter("username");
String password = request.getParameter("password");
demo3 demo3 = new demo3();
demo3.addUser(username,password);
request.getRequestDispatcher("/WEB-INF/pages/SRJsp.jsp").forward(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
2:
package oracle;
import sql.demo4;
public class demo3 {
public void addUser(String username, String password) {
demo4 demo4 = new demo4();
demo4.addUser(username,password);
}
}
3:
package sql;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.util.Properties;
public class demo4 {
private static Properties properties=null;
static{
try{
InputStream inputStream = demo4.class.getClassLoader().getResourceAsStream("jdbc.properties");
properties = new Properties();
properties.load(inputStream);
}catch(Exception e){
e.printStackTrace();
}
}
public void addUser(String username, String password) {
try {
//驱动创建
String driver = properties.getProperty("driver");
Class.forName(driver);
//建立链接
String url = properties.getProperty("url");
String name = properties.getProperty("username");
String psd= properties.getProperty("password");
Connection conn = DriverManager.getConnection(url, name, psd);
//数据库指令
PreparedStatement pps = conn.prepareStatement("insert into DBMS(class_accounts,class_password) values(?,?)");
//插入到具体的地方
pps.setString(1, username);
pps.setString(2, password);
//执行SQL
pps.executeUpdate();
pps.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
本人已经写好了写入数据,但是想把数据库中传入的值在返回来显示在HTML页面上。