为什么没有得到想要的结果?

为什么没有得到想要的结果?

zqj20073849
等级:

发表于：2007-09-14 19:17:10 楼主

大家好我是java新手,近来我在jdbc与sql的连接上出了问题.
请看代码:
package jdbctest;

import java.awt.*;
import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import javax.swing.BorderFactory;

public class Frame1
extends JFrame {
JPanel contentPane;
JButton jButton1 = new JButton();
JTextArea jTextArea1 = new JTextArea();
BorderLayout borderLayout1 = new BorderLayout();
public Frame1() {
try {
setDefaultCloseOperation(EXIT_ON_CLOSE);
jbInit();
}
catch (Exception exception) {
exception.printStackTrace();
}
}

/**
* Component initialization.
*
* @throws java.lang.Exception
*/
private void jbInit() throws Exception {
contentPane = (JPanel) getContentPane();
contentPane.setLayout(borderLayout1);
setSize(new Dimension(400, 300));
setTitle( "Frame Title ");
jButton1.setText( "JDBCConn ");
jButton1.addActionListener(new Frame1_jButton1_actionAdapter(this));
jTextArea1.setBorder(BorderFactory.createLoweredBevelBorder());
contentPane.add(jButton1, java.awt.BorderLayout.NORTH);
contentPane.add(jTextArea1, java.awt.BorderLayout.CENTER);
}

public void jButton1_actionPerformed(ActionEvent actionEvent) {
String RL = "jdbc:microsoft:sqlserver://9aa7049a5f0d45a.:1433;DatabaseName=xscj ";
String user = "sa ";//这里替换成你自已的数据库用户名
String password = " "; //这里替换成你自已的数据库用户密码
String sqlStr = "select * from xs ";
try{ //这里的异常处理语句是必需的.否则不能通过编译!
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ");
jTextArea1.append( "类实例化成功!\n ");
Connection con = DriverManager.getConnection(RL, user, password);
jTextArea1.append( "创建连接对像成功!\n ");
Statement st = con.createStatement();
jTextArea1.append( "创建Statement成功!\n ");
ResultSet rs = st.executeQuery(sqlStr);
jTextArea1.append( "操作数据表成功!\n ");
jTextArea1.append( "----------------!\n ");
while (rs.next()) {
jTextArea1.append(rs.getInt( "id ") + "\t ");
jTextArea1.append(rs.getString( "name ") + "\t ");
jTextArea1.append(rs.getInt( "course ") + "\t ");
jTextArea1.append(rs.getString( "totalscore ") + "\n ");
}
rs.close();
st.close();
con.close();
}
catch (Exception err) {
err.printStackTrace(System.out);
}
}
}

class Frame1_jButton1_actionAdapter
implements ActionListener {
private Frame1 adaptee;
Frame1_jButton1_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}

public void actionPerformed(ActionEvent actionEvent) {
adaptee.jButton1_actionPerformed(actionEvent);
}
}

package jdbctest;

import java.awt.Toolkit;
import javax.swing.SwingUtilities;
import javax.swing.UIManager;
import java.awt.Dimension;

public class JDBCApp {
boolean packFrame = false;

/**
* Construct and show the application.
*/
public JDBCApp() {
Frame1 frame = new Frame1();
// Validate frames that have preset sizes
// Pack frames that have useful preferred size info, e.g. from their layout
if (packFrame) {
frame.pack();
}
else {
frame.validate();
}

// Center the window
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
Dimension frameSize = frame.getSize();
if (frameSize.height > screenSize.height) {
frameSize.height = screenSize.height;
}
if (frameSize.width > screenSize.width) {
frameSize.width = screenSize.width;
}
frame.setLocation( (screenSize.width - frameSize.width) / 2,
(screenSize.height - frameSize.height) / 2);
frame.setVisible(true);
}

/**
* Application entry point.
*
* @param args String[]
*/
public static void main(String[] args) {
SwingUtilities.invokeLater(new Runnable() {
public void run() {
try {
UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());
}
catch (Exception exception) {
exception.printStackTrace();
}

new JDBCApp();
}
});
}
}

当运行这个工程的时候,弹出一个对话框:当点击JDBCoon时,下面的文本域显示 "类实力例化成功! " 这一点说明jdbc与sql建立了连接,但我跟人想问的是为什么在下面的文本域中没有显示出诸如 id,name,course等内容.如果要想达到预期的效果我应该怎么修改呢,顺便想问一下问题出在那里!
在此感谢诸位的赏光,本人不胜感激!

问题点数：20 回复次数：1 修改删除举报引用回复