主题:一个java连接数据库的问题
import java.awt.*;
import java.awt.event.*;
import java.io.*;
import java.sql.*;
import java.util.*;
class wo
{ static String colname;
public static void main(String[] args) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException e) {
System.out.println("" + e);
}
try {
String url = "jdbc:odbc:tongji";
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select distinct COMMENTS from chat1");
while(rs.next()){colname = rs.getString(1);}
stmt.close();
conn.close();
}
catch (Exception ex) {
ex.printStackTrace();
}
}
}
public class test5 extends Frame implements ActionListener
{static test5 frm1=new test5( );
static Button btn1=new Button("返回");
static Button btn2=new Button("退出");
static TextArea tt1=new TextArea();
int i,j,k;
static void play()
{
frm1.setLayout(new FlowLayout(FlowLayout.CENTER));
frm1.setTitle("科学算命");
frm1.setSize(300,300);
frm1.add(tt1);
System.out.println(wo.colname);
frm1.add(btn1);
btn1.addActionListener(frm1);
btn2.addActionListener(frm1);
frm1.add(btn2);
frm1.show( );
}
public void actionPerformed(ActionEvent e)
{
Button btn=(Button)e.getSource();
if(btn==btn1)
{test6.tt();
frm1.hide();}
else
test5.tt1.setText(wo.colname);
}
}
可是根本在文本与不显示数据库内容,请教大家帮忙
import java.awt.event.*;
import java.io.*;
import java.sql.*;
import java.util.*;
class wo
{ static String colname;
public static void main(String[] args) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException e) {
System.out.println("" + e);
}
try {
String url = "jdbc:odbc:tongji";
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select distinct COMMENTS from chat1");
while(rs.next()){colname = rs.getString(1);}
stmt.close();
conn.close();
}
catch (Exception ex) {
ex.printStackTrace();
}
}
}
public class test5 extends Frame implements ActionListener
{static test5 frm1=new test5( );
static Button btn1=new Button("返回");
static Button btn2=new Button("退出");
static TextArea tt1=new TextArea();
int i,j,k;
static void play()
{
frm1.setLayout(new FlowLayout(FlowLayout.CENTER));
frm1.setTitle("科学算命");
frm1.setSize(300,300);
frm1.add(tt1);
System.out.println(wo.colname);
frm1.add(btn1);
btn1.addActionListener(frm1);
btn2.addActionListener(frm1);
frm1.add(btn2);
frm1.show( );
}
public void actionPerformed(ActionEvent e)
{
Button btn=(Button)e.getSource();
if(btn==btn1)
{test6.tt();
frm1.hide();}
else
test5.tt1.setText(wo.colname);
}
}
可是根本在文本与不显示数据库内容,请教大家帮忙