jsp插入语句参数形式

最新推荐文章于 2022-06-21 16:12:41 发布

置顶张闻

最新推荐文章于 2022-06-21 16:12:41 发布

阅读量845

点赞数 1

本文链接：https://blog.csdn.net/weixin_41960668/article/details/79892494

版权

各位大神，江湖救急，在jsp中怎么把

"insert into student(id,name,age,gender,major)values("+id+",'"+name+"',"+age+",'"+gender+"','"+major+"')" 这种形式转换成这种：

String SQL = "INSERT INTO student(id,name,age,gender,major) VALUES(?,?,?,?,?)";

完整代码是这样的：

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> 
<%@ page import="java.sql.*"%> 
<% 
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%>"> <!--设置基础路径的,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"> 
		<!--<link rel="stylesheet" type="text/css" href="styles.css"> 
		
        String sql ="insert into login1(name , password) values(?,?)"
		--> 

	</head> 
		<body>
		<div style="position:absolute;z-index:-1;width:100%;height:100%;">
    		<img src=".\src\image8.png"; width="100%"; height="100%" ;>  
		</div>
		<% 
		request.setCharacterEncoding("UTF-8"); 
		String id=request.getParameter("id"); //它是一种取参数的方法。把jsp文件中的数据读取到出来。然后就可以封装利用起来。
		String name=request.getParameter("name"); 
		System.out.println(name); 
		String age=request.getParameter("age"); 
		String gender=request.getParameter("gender");
		String major=request.getParameter("major"); 
		Connection conn=null; 
		Statement stat=null; 
		ResultSet rs=null; 

		Class.forName("oracle.jdbc.driver.OracleDriver"); 
		String url="jdbc:oracle:thin:@localhost:1521:orcl";


		String user="y_user"; 
		String password="koy"; 
		conn=DriverManager.getConnection(url,user,password); 
		stat=conn.createStatement(); 

		rs=stat.executeQuery("insert into student(id,name,age,gender,major)values("+id+",'"+name+"',"+age+",'"+gender+"','"+major+"')");
	

		 /* String SQLQuery = "INSERT INTO student(id,name,age,gender,major) VALUES(?,?,?,?,?)";  
		 rs = stat.executeQuery(SQLQuery) ;
		out.print(SQLQuery); */

		%> 
		<center> 

		<% 
		if(rs.next()) 
		{ out.print("<br><h3>成功输入！</h3>");
		} 
		else{ out.print("<br><h3>输入失败！</h3>"); } 
		%> 

		<br> <a href=submit.jsp>返回信息输入页面</a> 
		</center> 

		<% 
		if(rs!=null) { rs.close(); } 
		if(stat!=null) { stat.close(); } 
		if(conn!=null) { conn.close(); } 
		%> 
		</body> 
</html>

张闻

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
jsp插入语句参数形式

各位大神，江湖救急，在jsp中怎么把"insert into student(id,name,age,gender,major)values("+id+",'"+name+"',"+age+",'"+gender+"','"+major+"')" 这种形式转换成这种：String SQL = "INSERT INTO student(id,name,age,gender,maj
复制链接

扫一扫