JDBCæ¥è¯¢æ°æ®è¿åç»jspé¡µé¢(æ³¨è§£æ¹å¼å®æ)

æéè¦jaråï¼

mysqlå¾è¡¨

eclipseæ¡æ¶

input.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"

pageEncoding="ISO-8859-1"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>Insert title here</title>

</head>

<body>

ID:<input type="text" name="id" /> <input type="button"

value="submit" id="btn">

</form>

</body>

var oBtn = document.getElementById("btn");

oBtn.onclick = function() {//jsç¹å»äºä»¶

var oInput = document.getElementsByTagName("input")[0];

var id = oInput.value;

location.href = "/jdbc/Servlet?id=" + id;

}

/* oBtn.onclick = function(){

document.getElementById("myForm").submit();

} */

</script>

</html>

return.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>Insert title here</title>

</head>

<body>

</body>

</html>

Jdbc.java

package com.jdbc;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.HashMap;

import java.util.Map;

public class Jdbc {

// å£°æConnectionå¯¹è±¡

java.sql.Connection con;

// é©±å¨ç¨åºå

String driver = "com.mysql.jdbc.Driver";

// URLæåè¦è®¿é®çæ°æ®åºåmydata

String url = "jdbc:mysql://localhost:3306/testmysql";

// MySQLéç½®æ¶çç¨æ·å

String user = "root";

// MySQLéç½®æ¶çå¯ç

String password = "root";

// ç»æé

java.sql.ResultSet rs;

java.sql.Statement statement = null;

public Map<String, Object> get(String userId) {

// éåæ¥è¯¢ç»æé

try {

// å è½½é©±å¨ç¨åº

Class.forName(driver);

// 1.getConnection()æ¹æ³ï¼è¿æ¥MySQLæ°æ®åºï¼ï¼

con = DriverManager.getConnection(url, user, password);

// 2.åå»ºstatementç±»å¯¹è±¡ï¼ç¨æ¥æ§è¡SQLè¯å¥ï¼ï¼

statement = con.createStatement();

// è¦æ§è¡çSQLè¯å¥

String sql = "SELECT * FROM student WHERE Id=" + userId;

// 3.ResultSetç±»ï¼ç¨æ¥åæ¾è·åçç»æéï¼ï¼

rs = statement.executeQuery(sql);

Map<String, Object> m = null;

while (rs.next()) {

String Id = rs.getString("Id");

String Name = rs.getString("Name");

String Sex = rs.getString("Sex");

String Age = rs.getString("Age");

m = new HashMap<String, Object>();

m.put("Id", Id);

m.put("Name", Name);

m.put("Sex", Sex);

m.put("Age", Age);

}

return m;

} catch (Exception e) {

System.out.println("Sorry,can`t find the Driver!");

} finally {

try {

rs.close();

} catch (SQLException e) {

e.printStackTrace();

}

try {

statement.close();

} catch (SQLException e1) {

e1.printStackTrace();

}

try {

con.close();

} catch (SQLException e) {

e.printStackTrace();

}

return null;

}

Servlet.java

package com.jdbc;

import java.io.IOException;

import java.util.Map;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

@WebServlet("/Servlet")

public class Servlet extends HttpServlet {

private static final long serialVersionUID = 1L;

protected void service(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException {

String userId = request.getParameter("id");

Map<String, Object> map = new Jdbc().get(userId);

request.setAttribute("map", map);

request.getRequestDispatcher("/return.jsp").forward(request,response);

}

æµè¯ç»æ

JDBCæ¥è¯¢æ°æ®è¿åç»jspé¡µé¢(æ³¨è§£æ¹å¼å®æ)

相关推荐

JDBCæ¥è¯¢æ°æ®è¿åç»jspé¡µé¢(æ³¨è§£æ¹å¼å®æ)