📄 image2.jsp

📁 一本jsp自学教材

💻 JSP

字号:

<%@ page contentType="text/html;charset=gb2312"%>   
<%@ page import="java.sql.*"   %>   
<%@ page import="java.util.*"%>   
<%@ page import="java.text.*"%>   
<%@ page import="java.io.*"%>   
<html>   
<body>   
<%
  String name=request.getParameter("name");
  name=new String(name.getBytes("ISO-8859-1"));  
  String info=request.getParameter("info"); 
  info=new String(info.getBytes("ISO-8859-1"));  
  String image=request.getParameter("image");  
  String driverName="com.mysql.jdbc.Driver";
  String username="root";
  String password="yesterdayn";
  String dbName="study";
  String tableName="roles"; 
  String url="jdbc:mysql://localhost/"+dbName+"?characterEncoding=GBK";  
  try{
  Class.forName("com.mysql.jdbc.Driver");
  //建立同数据库的连接对象
  Connection conn=DriverManager.getConnection(url,username,password);  
  FileInputStream fis=new FileInputStream(image);   
  String sql="INSERT INTO "+tableName+"(id,name,info,image)values(?,?,?,?)";   
  PreparedStatement  pstmt=conn.prepareStatement(sql); 
  pstmt.setInt(1,0);     
  pstmt.setString(2,name); 
  pstmt.setString(3,info);    
  pstmt.setBinaryStream(4,fis,fis.available());   
  pstmt.execute(); 
  pstmt.close();
  conn.close();  
}
catch(Exception e)
{
 out.print(e.toString());
}
out.print("插入数据库成功！<BR>");
out.print("<A href=image3.jsp?name="+name+" >查看</A><BR>");
%>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -