String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433;databasename=xyspjyw"; //1433是数据库的端口,"li"是你的数据库名称
String userName = "sa"; //sa是数据库的超级用户,最好不要换别的名字,权限问题
String userPwd = "sa"; //sa的密码
Connection con=null;
try {
Class.forName(driverName).newInstance();
con = DriverManager.getConnection(dbURL, userName, userPwd);
Statement stmt=con.createStatement(); //建立Statement对象
String info_title=(String)request.getAttribute("info_Title");
String info_content=request.getParameter("info_content");
info_content=new String(info_content.getBytes("8859_1"),"gb2312");
FileInputStream str=new FileInputStream(info_content);
String info_linkman=(String)request.getAttribute("info_linkman");
String info_phone=(String)request.getAttribute("info_phone");
String info_email=(String)request.getAttribute("info_qq");
String sql="insert into picturenews(info_title,info_content,info_linkman,info_phone,info_email) values(?,?,?,?,?)";
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setString(1,info_title);
pstmt.setBinaryStream(2,str,str.available());
pstmt.setString(3,info_linkman);
pstmt.setString(4,info_phone);
pstmt.setString(5,info_email);
pstmt.execute();//将数据存入数据库
out.println("Success,You Have Insert an Image Successfully");
}
catch (Exception e)
{
e.printStackTrace();
}
finally{
try {
if(dbConn!=null)
con.close();
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
%>
错误:
展开