同意楼上,肯定可以,weblogic不可能去限制这个,应该是你的代码有问题。
解决方案 »
- Document is invalid: no grammar found.
- servlet调用 hibernate 存数据时出了问题,请各位高手帮帮忙
- 50分!打印的时候用什么才可以生成一个word里面的表单并进行修改打印啊?
- 用spring配置MySQL的数据源无法载入驱动类
- *求* 网站访问统计程序
- Hibernate面向对象和普通数据库
- server.xml中Context设置的问题
- iis怎么才能用servlet?
- 请问在jsp中使用applet,web-inf要如何配置吗?
- 如何把.SWF文件写入JSP页
- weblogic中jsp通过javabean连接sqlserver2000数据库的问题
- 问个使用JAVABEAN问题Vector是什么功能?
jsp:
<%@ page import = "java.sql.ResultSet"%>
<!--%@ page import = "com.microsoft.jdbc.selserver.*"-->
<html><body>
<jsp:useBean id= "bean" class= "test.insert" scope= "page"/>
begin
<%String strSQL = "select * from pepole ";
String myurl = "jdbc:microsoft:sqlserver://192.168.0.251:1433;DatabaseName = JDBCtest";
String user = "sa";
String password = "lib";
String databasename = "jdbctest";
bean.setUrl(myurl);
bean.setUser(user);
bean.setPassword(password);
bean.setDatabasename(databasename);
ResultSet rs = bean.connectdb(strSQL);
if(rs != null){
rs.close();%>connect successfully
<%}else {%>connect fail<%}%>
</body></html>javabean:package test;import com.microsoft.jdbc.sqlserver.*;
import java.sql.*;
import java.net.URL.*;public class insert{ private String myurl = new String("");//"jdbc:microsoft:sqlserver://192.168.0.251:1433";
private String user = new String("");//"bigfrog";
private String password = new String("");//"iamfrog";
private String databasename = new String("");//"jdbctest";
public void setUrl(String myurl){ this.myurl = myurl; }
public void setUser(String user){ this.user = user;}
public void setPassword(String password){this.password = password; }
public void setDatabasename(String databasename){ this.databasename = databasename;}
public String getUrl(){ return myurl;}
public String getUser(){ return user;}
public String getPassword(){ return password;}
public String getDatabasename(){ return databasename;}
public boolean bcon=false;
public boolean bstmt=false;
public boolean brss=false; public ResultSet connectdb(String query){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager.getConnection(myurl,user,password);
stmt = con.createStatement();
rss = stmt.executeQuery(query);
rss.next();
}catch(SQLException ex){
...
}
catch(java.lang.Exception ex){
....
}
return rss;
}
}我发现数据库根本就没连上 但我再本地测试我的bean就可以连
Arias(永恒之道) 帮我看看呀 谢了
在Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");con = DriverManager.getConnection(myurl,user,password);
加几举输出语句看看是什么原因!
<%@ page import = "java.sql.*" %><%
String myurl = "jdbc:microsoft:sqlserver://192.168.0.251:1433;DatabaseName = JDBCtest";
String user = "sa";
String password = "";Class.forName("org.gjt.mm.mysql.Driver");
Connection con = DriverManager.getConnection(myurl,user,password);
Statement stmt = con.createStatement();
out.print ("OK");
%> 同时,MSSQLServer的登录验证方式要用混合认证
注意端口是不是1433
最好不要用空密码
有问题再贴
给你贴一段简单的jdbc连接oracle的代码吧:import java.sql.*;
import javax.sql.*;public class MyJdbc2 {
public static void main(String args[]) {
Connection connMy = null;
ResultSet rsMy = null;
Statement stmtMy = null;
String url = "jdbc:oracle:thin:@localhost:1521:ooooora";
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
connMy = DriverManager.getConnection(url, "scott", "tiger");
stmtMy = connMy.createStatement(); //对jdbc1表和jdbc2表的联合查询操作
rsMy = stmtMy.executeQuery(
"select jdbc1.id,jdbc1.jname,jdbc2.jdetail from jdbc1,jdbc2");
while (rsMy.next()) {
System.out.print(rsMy.getInt("id"));
System.out.print("\t");
System.out.print(rsMy.getString("jname"));
System.out.print("\t");
System.out.print(rsMy.getString("jdetail"));
System.out.println();
} //对jdbc1表的插入操作
stmtMy.executeUpdate("insert into jdbc1 values(22,'well done!')"); //对jdbc1表的修改操作
stmtMy.executeUpdate("update jdbc1 set jname='ok!' where id=22"); //对jdbc1表和jdbc2表进行删除操作
stmtMy.executeUpdate("delete jdbc2 where id2=22");
stmtMy.executeUpdate("delete jdbc1 where id=22"); //释放资源
rsMy.close();
stmtMy.close();
connMy.close(); }
catch (Exception e) {
e.printStackTrace();
}
finally {
try {
if (rsMy != null) {
rsMy.close();
}
if (stmtMy != null) {
stmtMy.close();
}
if (connMy != null) {
connMy.close();
}
}
catch (Exception e) {
e.printStackTrace();
}
}
}
}