解决方案 »
- 菜鸟请教连接数据库并更新的javabean
- dtree中checkbox问题
- 很急的问题,请你帮帮忙
- 帮帮忙 数据库问题
- 如何替换java应用程序的系统窗口界面
- JRE问题!急@@@@@@@@@!!!!!!!!!!
- 请问jbuilder下怎么改变包名? 以及如何把现有的包放到新建的包中 ?
- 问一个Swing做界面算是设计模式方面的问题,语言上应如何去实现
- (高分啊………)keyword: tomcat 、refresh、session-->为什么页面不能自动刷新?
- 我是一个java 初学者,请问在那里有java文档下载较好的网站?(NULL〕
- socket如果越过防火墙
- 有关struts2问题,高手进!
这句不对,要三个参数,你只传了一个,虽然你把三个写一起变成一个了,但这样不行。
分开写
getConnection
public static Connection getConnection(String url)
throws SQLExceptionAttempts to establish a connection to the given database URL. The DriverManager attempts to select an appropriate driver from the set of registered JDBC drivers. Parameters:
url - a database url of the form jdbc:subprotocol:subname
Returns:
a connection to the URL
Throws:
SQLException - if a database access error occurs
你把while语句改成rs.next()试试
JDBC连接MSSQLserverClass.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb";
//mydb为数据库
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
这样
try {
Class.forName(drivername);
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
rs.next();
jta_data.setText(rs.getString(1)+"");
jta_data.setText(rs.getString(2)+"");
jta_data.setText(rs.getString(3)+"");
jta_data.setText(rs.getString(4)+"");
} catch (Exception e1) {
// TODO: handle exception
e1.printStackTrace();
}
控制台有数据输出,但是窗体中textarea内没有数据输出。
截图如下
2 admin admin null
4 ceshi test [email protected]
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid operation for the current cursor position.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.validateCursorPosition(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source)
at exa1.db2$1.actionPerformed(db2.java:58)
Class.forName(drivername);
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
String text="";
while (rs.next()) {
text+=rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+"\n";
}
jta_data.setText(text);
} catch (Exception e1) {
// TODO: handle exception
e1.printStackTrace();
}