就是在JTextArea里能显示数据库里一个表的表内容就行,我大概把程序写在下面,不是很全,有人能帮我改下并实现下吗,谢谢拉
(*_*)
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class DBcon extends JFrame
{
JTextArea jta;
JButton btn1;
JScrollPane jsp;
DBcon(String s)
{
super(s);
jta=new JTextArea();
btn1=new JButton("打开");
jsp=new JScrollPane(jta);
add(jsp,BorderLayout.NORTH);
add(btn1,BorderLayout.SOUTH);
setSize(300,300);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setVisible(true);
}
private void Query()
{
try
{
Class.forName("sun:jdbc:odbc:JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:数据源名");
Statement s = con.createStatement();
s.executeUpdate("修改或添加的SQL语句");
ResultSet rs = s.executeQuery("查询的Sql语句");
while(rs.next())
{
rs.getString("字段名");
}
}catch(Exception ex)
{
System.out.println(ex.getMessage());
}
} public static void main(String[] args)
{
DBcon dbcon = new DBcon("传递数据");
}
}
(*_*)
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class DBcon extends JFrame
{
JTextArea jta;
JButton btn1;
JScrollPane jsp;
DBcon(String s)
{
super(s);
jta=new JTextArea();
btn1=new JButton("打开");
jsp=new JScrollPane(jta);
add(jsp,BorderLayout.NORTH);
add(btn1,BorderLayout.SOUTH);
setSize(300,300);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setVisible(true);
}
private void Query()
{
try
{
Class.forName("sun:jdbc:odbc:JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:数据源名");
Statement s = con.createStatement();
s.executeUpdate("修改或添加的SQL语句");
ResultSet rs = s.executeQuery("查询的Sql语句");
while(rs.next())
{
rs.getString("字段名");
}
}catch(Exception ex)
{
System.out.println(ex.getMessage());
}
} public static void main(String[] args)
{
DBcon dbcon = new DBcon("传递数据");
}
}
jsa.append(rs.getString("字段名")+"\n");
}..........
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class DBcon extends JFrame
{
JTextArea jta;
JButton btn1;
JScrollPane jsp;
DBcon(String s)
{
super(s);
jta=new JTextArea();
btn1=new JButton("打开");
jsp=new JScrollPane(jta);
add(jsp,BorderLayout.NORTH);
add(btn1,BorderLayout.SOUTH);
setSize(300,300);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
btn1.addMouseListener(new MouseAdapter(){ public void mouseClicked(MouseEvent e) {
Query();
}
});
setVisible(true);
}
private void Query()
{
try
{
//Class.forName("jdbc:odbc:JdbcOdbcDriver");
//Connection con = DriverManager.getConnection("jdbc:odbc:stu");
//Statement s = con.createStatement();
//s.executeUpdate("修改或添加的SQL语句");
//ResultSet rs = s.executeQuery("select * from student where id = 1");
//while(rs.next())
//{
jta.append("name\n");
//jta.append(rs.get("name"));
//}
//rs.close();
//s.close();
//con.close();
}catch(Exception ex)
{
System.out.println(ex.getMessage());
}
} public static void main(String[] args)
{
DBcon dbcon = new DBcon("传递数据");
}
}