test.jsp
----------------------------------------------------------------
<%@ page contentType="text/html; charset=utf-8" %>
<html>
<head>
<title>
test1
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head><body bgcolor="#ffffff">
<form name="form1" method="post" action="action.jsp">
TEXT<textarea name="txt" cols="40" rows="10" id="txt"></textarea>
<input type="submit" name="Submit" value="submit">
</form>
</body>
</html>
action.jsp
--------------------------------------------------------
<%@ page contentType="text/html; charset=utf-8" %>
<%@ page import = "java.io.*" %>
<%@ page import = "java.sql.*" %>
<%@ page import = "javax.util.zz.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>
action
</title>
</head>
<body bgcolor="#ffffff">
<%
request.setCharacterEncoding("utf-8");
String txt = request.getParameter("txt");
String id = "sadfsadsfsafd";
%>
ID:<%=id%>
<br><br>
Source:<%=txt%>
<%
FileOutputStream fout = new FileOutputStream("c:/korean.htm");
fout.write(txt.getBytes("utf-8"));
fout.flush();
fout.close();
%><%
byte[] b = FileDeal.readBinaryFile(new File("c:/korean.htm"),1024);
String s = new String(b,"utf-8");
%>
<br><br>
From file:<%=s%><%
String s1 = new String(txt.getBytes("utf-8"));
Connection conn = Database.getOracleConnection("jdbc:oracle:thin:@ip:port:dbname","xxx","xxx");
Database.executeSQL(conn,"insert into tbg_ip_handle (ip,p_login,p_message,p_comment,testvarchar) values('"+id+"',1,1,1,'"+s1+"')");
Database.writeClob(conn,"tbg_ip_handle","testclob","ip='"+id+"'",s1);
conn.commit();%>
<%
String sql = "select * from table_name where ip='"+id+"'";
PreparedStatement pstmt = null;
String fromclob = "";
String fromvarchar = ""; try { pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
if(rs.next()){
fromclob = new String(Database.readClob(rs,"testclob").getBytes(),"utf-8");
fromvarchar = new String(rs.getString("testvarchar").getBytes(),"utf-8");
}
}
catch (SQLException e) {
e.printStackTrace();
}
catch (IOException e) {
e.printStackTrace();
}
finally {
Database.close(conn, pstmt);
}%>
<br><br>
From DB:<%="<br><br> fromclob="+fromclob+"<br><br> fromvarchar="+fromvarchar%>
</body>
</html>
----------------------------------------------------------------
<%@ page contentType="text/html; charset=utf-8" %>
<html>
<head>
<title>
test1
</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head><body bgcolor="#ffffff">
<form name="form1" method="post" action="action.jsp">
TEXT<textarea name="txt" cols="40" rows="10" id="txt"></textarea>
<input type="submit" name="Submit" value="submit">
</form>
</body>
</html>
action.jsp
--------------------------------------------------------
<%@ page contentType="text/html; charset=utf-8" %>
<%@ page import = "java.io.*" %>
<%@ page import = "java.sql.*" %>
<%@ page import = "javax.util.zz.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>
action
</title>
</head>
<body bgcolor="#ffffff">
<%
request.setCharacterEncoding("utf-8");
String txt = request.getParameter("txt");
String id = "sadfsadsfsafd";
%>
ID:<%=id%>
<br><br>
Source:<%=txt%>
<%
FileOutputStream fout = new FileOutputStream("c:/korean.htm");
fout.write(txt.getBytes("utf-8"));
fout.flush();
fout.close();
%><%
byte[] b = FileDeal.readBinaryFile(new File("c:/korean.htm"),1024);
String s = new String(b,"utf-8");
%>
<br><br>
From file:<%=s%><%
String s1 = new String(txt.getBytes("utf-8"));
Connection conn = Database.getOracleConnection("jdbc:oracle:thin:@ip:port:dbname","xxx","xxx");
Database.executeSQL(conn,"insert into tbg_ip_handle (ip,p_login,p_message,p_comment,testvarchar) values('"+id+"',1,1,1,'"+s1+"')");
Database.writeClob(conn,"tbg_ip_handle","testclob","ip='"+id+"'",s1);
conn.commit();%>
<%
String sql = "select * from table_name where ip='"+id+"'";
PreparedStatement pstmt = null;
String fromclob = "";
String fromvarchar = ""; try { pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
if(rs.next()){
fromclob = new String(Database.readClob(rs,"testclob").getBytes(),"utf-8");
fromvarchar = new String(rs.getString("testvarchar").getBytes(),"utf-8");
}
}
catch (SQLException e) {
e.printStackTrace();
}
catch (IOException e) {
e.printStackTrace();
}
finally {
Database.close(conn, pstmt);
}%>
<br><br>
From DB:<%="<br><br> fromclob="+fromclob+"<br><br> fromvarchar="+fromvarchar%>
</body>
</html>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货