String sSql = "INSERT INTO news VALUES(?,?,?,?,?)";PreparedStatement pstmt = con.prepareStatement(sSql);
String title=request.getParameter("bt");
String new1=request.getParameter("new");
String sta=request.getParameter("sta"); String content=request.getParameter("txt1");
byte[] pic = content.getBytes("8859_1");
ByteArrayInputStream baisss = new ByteArrayInputStream(pic);
InputStreamReader bais = new InputStreamReader(baisss,"8859_1"); pstmt.setInt(1,id);
pstmt.setString(2,title);
pstmt.setCharacterStream(3,bais,pic.length);
pstmt.setString(4,new1);
pstmt.setString(5,sta);
pstmt.execute();
String title=request.getParameter("bt");
String new1=request.getParameter("new");
String sta=request.getParameter("sta"); String content=request.getParameter("txt1");
byte[] pic = content.getBytes("8859_1");
ByteArrayInputStream baisss = new ByteArrayInputStream(pic);
InputStreamReader bais = new InputStreamReader(baisss,"8859_1"); pstmt.setInt(1,id);
pstmt.setString(2,title);
pstmt.setCharacterStream(3,bais,pic.length);
pstmt.setString(4,new1);
pstmt.setString(5,sta);
pstmt.execute();
VARCHAR类型存储的相对多些!