java能连上数据库_jsp usebean调用不行_java中能连接数据库，放在jsp中就连接不上了...

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();

}

}

%>

错误：

展开