朋友帮帮忙,能解决问题者必给加分

yongshi128 2007-10-26 07:46:33
是用jbuilder弄了一个框架
jdbc已经连接好了数据库,关于jdbc和数据库的设置应该都设置好了
想获取数据库中某个表的字段值与界面中jtextfiled中的字符串相比较,
定义了一个按钮事件来实现,方法代码如下:
void jButton1_actionPerformed(ActionEvent e) {

String t=queryDataSet1.getString("id");
String t2=queryDataSet1.getString("password");
String s1=jTextField1.getText();
String s2=jTextField2.getText();
if(s1.equals(t) && s2.equals(t2))

jTextField1.setText("jjjkljfo");
其中的queryDataSet的query属性应该设置正确了,但是当我按这个按钮的时候确没有反应
就是说应该是不能读取数据库中某个表的字段值。
希望高手指点
解决了必给加分
谢谢~~~~~~~~~
...全文
135 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
macongbin88 2007-12-27
  • 打赏
  • 举报
回复
不是很懂jbuilder
下面两点可能对你查找原因有帮助:
1.queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select *\nfrom logo1", null, true, Load.ALL));

queryDataSet1 调用了setQuery方法就能从数据库中拿到数据集了吗?是不是应该有个什么方法让它执行查询

2. String t=queryDataSet1.getString("id");
String t2=queryDataSet1.getString("password");

如果在1的代码中已经取到了数据集,那么你这里调用去字段值的方法拿到的是第几条纪录(如果纪录有多条的话)
yongshi128 2007-10-26
  • 打赏
  • 举报
回复
页面代码如下:
package 用户登陆信息;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import com.borland.dx.sql.dataset.*;
import java.sql.*;

public class Frame1 extends JFrame {
JPanel contentPane;
JLabel jLabel1 = new JLabel();
JLabel jLabel2 = new JLabel();
JTextField jTextField1 = new JTextField();
JLabel jLabel3 = new JLabel();
JTextField jTextField2 = new JTextField();
Database database1 = new Database();
QueryDataSet queryDataSet1 = new QueryDataSet();
JButton jButton1 = new JButton();
JButton jButton2 = new JButton();




//Construct the frame
public Frame1() {
enableEvents(AWTEvent.WINDOW_EVENT_MASK);
try {
jbInit();
}
catch(Exception e) {
e.printStackTrace();
}
}
//Component initialization
private void jbInit() throws Exception {
contentPane = (JPanel) this.getContentPane();
jLabel1.setFont(new java.awt.Font("Serif", 1, 40));
jLabel1.setText("用户登陆窗口");
jLabel1.setBounds(new Rectangle(111, 29, 255, 75));
contentPane.setLayout(null);
this.setSize(new Dimension(484, 429));
this.setTitle("Frame Title");
jLabel2.setFont(new java.awt.Font("Serif", 1, 25));
jLabel2.setText("用户名");
jLabel2.setBounds(new Rectangle(32, 145, 81, 43));
jTextField1.setFont(new java.awt.Font("Serif", 1, 25));
jTextField1.setToolTipText("请输入用户名");
jTextField1.setText("jTF1");
jTextField1.setBounds(new Rectangle(135, 132, 232, 61));
jTextField1.addActionListener(new Frame1_jTextField1_actionAdapter(this));
jLabel3.setFont(new java.awt.Font("Serif", 1, 25));
jLabel3.setText("密码");
jLabel3.setBounds(new Rectangle(42, 264, 58, 47));
jTextField2.setFont(new java.awt.Font("Serif", 1, 25));
jTextField2.setToolTipText("请输入密码");
jTextField2.setText("jTF2");
jTextField2.setBounds(new Rectangle(133, 254, 238, 67));



database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:student", "sa", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select *\nfrom logo1", null, true, Load.ALL));


jButton1.setBounds(new Rectangle(74, 359, 119, 46));
jButton1.setFont(new java.awt.Font("Serif", 1, 25));
jButton1.setText("确定");
jButton1.addActionListener(new Frame1_jButton1_actionAdapter(this));
jButton1.addActionListener(new Frame1_jButton1_actionAdapter(this));
jButton2.setBounds(new Rectangle(288, 357, 142, 47));
jButton2.setFont(new java.awt.Font("Serif", 1, 25));
jButton2.setText("重新设置");
jButton2.addActionListener(new Frame1_jButton2_actionAdapter(this));
jButton2.addActionListener(new Frame1_jButton2_actionAdapter(this));
contentPane.add(jLabel1, null);
contentPane.add(jLabel2, null);
contentPane.add(jTextField1, null);
contentPane.add(jLabel3, null);
contentPane.add(jTextField2, null);
contentPane.add(jButton2, null);
contentPane.add(jButton1, null);
}
//Overridden so we can exit when window is closed
protected void processWindowEvent(WindowEvent e) {
super.processWindowEvent(e);
if (e.getID() == WindowEvent.WINDOW_CLOSING) {
System.exit(0);
}
}

void jButton2_actionPerformed(ActionEvent e) {
jTextField1.setText("jjjkljfo");
}

void jButton1_actionPerformed(ActionEvent e) {

String t=queryDataSet1.getString("id");
String t2=queryDataSet1.getString("password");
String s1=jTextField1.getText();
String s2=jTextField2.getText();
if(s1.equals(t) && s2.equals(t2))

jTextField1.setText("jjjkljfo");








}

class Frame1_jButton2_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;

Frame1_jButton2_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton2_actionPerformed(e);
}
}

class Frame1_jButton1_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;

Frame1_jButton1_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}

void jTextField1_actionPerformed(ActionEvent e) {

}
}

class Frame1_jTextField1_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;

Frame1_jTextField1_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jTextField1_actionPerformed(e);
}
}

class Frame1_jButton1_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;

Frame1_jButton1_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}

class Frame1_jButton2_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;

Frame1_jButton2_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton2_actionPerformed(e);
}
}
zhb_821012 2007-10-26
  • 打赏
  • 举报
回复
没反应那是没提交了
把页面代码拿出来啊
光看这个没用吧

62,623

社区成员

发帖
与我相关
我的任务
社区描述
Java 2 Standard Edition
社区管理员
  • Java SE
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧