java中jatable连接数据库步骤及其获取数据方法
java\u4e2djatable\u8fde\u63a5\u6570\u636e\u5e93\u6b65\u9aa4\u53ca\u5176\u83b7\u53d6\u6570\u636e\u65b9\u6cd5//\u627e\u9a71\u52a8
Class.forName("oracle.jdbc.driver.OracleDriver");
//\u5efa\u8fde\u63a5
Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:oracle", "scott","tiger");
//\u5efa\u901a\u9053
Statement stm=conn.createStatement();
//\u6267\u884csql\u8bed\u53e5
int iden=stm.executeUpdate(sql);
1.\u6ce8\u518c\u9a71\u52a8
Class.forname("com.mysql.jdbc.Driver");//\u8fd9\u662f\u8fde\u63a5mysql\u6570\u636e\u5e93\u7684\u9a71\u52a8
2.\u83b7\u53d6\u6570\u636e\u5e93\u8fde\u63a5
java.sql.Connection conn=java.sql.DriverManager.getConnection(); 3.\u83b7\u53d6\u8868\u8fbe\u5f0f
java.sql.Statement stmt=conn.createStatement("jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=GBK","root","null");//\u4e09\u4e2a\u53c2\u6570\u5206\u522b\u662f\u6570\u636e\u5e93\u8fde\u63a5\u7684URL,\u7528\u6237\u540d\uff0c\u5bc6\u7801 4.\u6267\u884cSQL
java.sql.ResultSet rs=stmt.executeQuery("select * from user"); 5.\u663e\u793a\u7ed3\u679c\u96c6\u91cc\u9762\u7684\u6570\u636e
while(rs.next()){
System.out.println(rs.getInt(1));
System.out.println(rs.getString("username"));
System.out.println(rs.getString("password"));
System.out.pringln();
}//\u6267\u884c\u63d2\u5165\u8bed\u53e5
//stmt.executeUpdate("insert into user values(1,'\u4e2d\u6587','345')");
6.\u91ca\u653e\u8d44\u6e90
rs.close();
stmt.close();
conn.close();
import javax.swing.*;
import javax.swing.table.JTableHeader;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
public class Test extends JFrame{
// 定义组件
private JScrollPane scpDemo;
private JTableHeader jth;
private JTable tabDemo;
private JButton btnShow;
// 构造方法
public Test(){
// 窗体的相关属性的定义
super("JTable数据绑定示例");
this.setSize(330,400);
this.setLayout(null);
this.setLocation(100,50);
// 创建组件
this.scpDemo = new JScrollPane();
this.scpDemo.setBounds(10,50,300,270);
this.btnShow = new JButton("显示数据");
this.btnShow.setBounds(10,10,300,30);
// 给按钮注册监听
this.btnShow.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ae){
btnShow_ActionPerformed(ae);
}
});
// 将组件加入到窗体中
add(this.scpDemo);
add(this.btnShow);
// 显示窗体
this.setVisible(true);
}
// 点击按钮时的事件处理
public void btnShow_ActionPerformed(ActionEvent ae){
// 以下是连接数据源和显示数据的具体处理方法，请注意下
try{
// 获得连接
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:localServer","sa","");
// 建立查询条件
String sql = "select * from localServer";
PreparedStatement pstm = conn.prepareStatement(sql);
// 执行查询
ResultSet rs = pstm.executeQuery();
// 计算有多少条记录
int count = 0;
while(rs.next()){
count++;
}
rs = pstm.executeQuery();
// 将查询获得的记录数据，转换成适合生成JTable的数据形式
Object[][] info = new Object[count][4];
count = 0;
while(rs.next()){
info[count][0] = Integer.valueOf( rs.getInt("id"));
info[count][1] = rs.getString("name");
info[count][2] = Integer.valueOf( rs.getInt("age") );
info[count][3] = rs.getString("sex");
count++;
}
// 定义表头
String[] title = {"学号","姓名","年龄","性别"};
// 创建JTable
this.tabDemo = new JTable(info,title);
// 显示表头
this.jth = this.tabDemo.getTableHeader();
// 将JTable加入到带滚动条的面板中
this.scpDemo.getViewport().add(tabDemo);
}catch(ClassNotFoundException cnfe){
JOptionPane.showMessageDialog(null,"数据源错误","错误",JOptionPane.ERROR_MESSAGE);
}catch(SQLException sqle){
JOptionPane.showMessageDialog(null,"数据操作错误","错误",JOptionPane.ERROR_MESSAGE);
}
}
public static void main(String[] args){
new Test();
}
}
抱歉，那个Object[][]还可以用Vector代替的
用Vector更好些
上面那个程序已经在我自己的机器上运行没有问题了
你看下吧
绛旓細import java.awt.event.ActionListener;import java.sql.*;public class Test extends JFrame{ // 瀹氫箟缁勪欢 private JScrollPane scpDemo;private JTableHeader jth;private JTable tabDemo;private JButton btnShow;// 鏋勯犳柟娉 public Test(){ // 绐椾綋鐨鐩稿叧灞炴х殑瀹氫箟 super("JTable鏁版嵁缁戝畾绀轰緥")...
绛旓細鍙互浣跨敤Swing鐨DefaultTableModel绫汇侱efaultTableModel model = new DefaultTableModel(); // 鏂板缓涓涓粯璁ゆ暟鎹ā鍨 JTablt table = new JTable(model); // 鐢ㄦ暟鎹ā鍨嬪垱寤篔Table锛孞Table浼氳嚜鍔ㄧ洃鍚埌鏁版嵁妯″瀷涓殑鏁版嵁鏀瑰彉骞舵樉绀哄嚭鏉 JScrollPane jsp = new JScrollPane(table); // 鐢ㄥ垪琛ㄥ垱寤哄彲婊氬姩...
绛旓細string =new String[]{"鍖哄煙缂栧彿","鍖哄煙鍚嶇О","鍖哄煙鍧愭爣","鎬诲崱鏁","璁板綍鏃堕棿"};object =new Object[][]{{null,null,null,null,null}};jTable1.setModel(new javax.swing.table.DefaultTableModel(object, string));鍐鐨鏂规硶瀵筼bject浜岀淮鏁版嵁璧嬪煎氨琛屼簡銆傚悓鏍疯嫢鏄兂鎶婅〃涓殑鏁版嵁璇诲嚭鏉ュ氨鏄...
绛旓細JTable澶у皬鍥哄畾浜嗭紝搴旇鎶奐Table鏀惧湪JScrollPane閲岄潰 JScrollPane scrollPane = new JScrollPane(); scrollPane.setViewportView(table);
绛旓細鏈绠鍗曠殑鏂规硶锛屼綘鍙互浣跨敤JTable鐨鏋勯犲嚱鏁拌繘琛屾坊鍔狅紝濡備笅锛欽Table(Object[][] rowData, Object[] columnNames)鏋勯犱竴涓 JTable 鏉ユ樉绀轰簩缁存暟缁 rowData 涓殑鍊硷紝鍏跺垪鍚嶇О涓篶olumnNames銆傚彟澶栦綘鍙互鏌ョ湅java API鑾峰彇淇℃伅锛
绛旓細("num");\x0d\x0a//鎶婁互涓婃暟鎹坊鍔犲埌琛ㄦ牸妯″瀷鐨涓琛屼腑\x0d\x0a\x0d\x0amodel.addRow(new Object[]{dt,name,pname,i});\x0d\x0a}\x0d\x0a鏈鍚,鐢ㄦā鍨嬬敓鎴愯〃鏍糪x0d\x0aJTable table=new JTable(model);\x0d\x0a褰撶劧,杩樻湁涓浜涘叾瀹冪殑鎿嶄綔,姣斿鎶婅〃鏍兼樉绀哄嚭鏉,琛ㄦ牸鐨勫瓧浣...
绛旓細缁欎綘涓濊矾鍚~鑷繁鍐欎釜TableModel 缁ф壙鑷 DefaultTableModel,閲岄潰鏈変釜 Object getValueAt(int row, int column)杩斿洖 row 鍜 column 澶勫崟鍏冩牸鐨灞炴у笺傜劧鍚庨噸鍐 void fireTableChanged(TableModelEvent e){ 鍦ㄨ繖閲岃幏鍙栬鏍,棰滆壊鏄剧ず鍒板彸杈 } 鑷繁璇曡瘯~~...
绛旓細妤间富浣犲ソ锛佷綘鐨琛ㄦ渶鍚庝竴琛屽叏涓虹┖鍚с傛垨鑰JTABLE榛樿鏈鍚庝竴琛屾墍鏈夊煎叏涓虹┖ 妤间富鏄兂灏咼TABLE涓殑姣忎竴琛屾坊鍔犲埌鏁版嵁搴撲腑锛屽嵈鐢‵OR寰幆寰幆璧嬪硷紝鏈鍚巆1-c9绛変簬鐨勬槸浣犺〃涓渶鍚庝竴琛岀殑鏁版嵁銆傛ゼ涓诲簲璇ユ妸杩炴帴鏀惧埌for寰幆涔嬪墠锛屽皢鏌ヨ璇彞鏀惧埌for寰幆涔嬪唴锛佷笉鐭ラ亾妤间富鏄繖涓剰鎬濅笉锛
绛旓細1銆佽嚜瀹氫箟娓叉煋鍣紝鑷繁娣诲姞銆傦紙鎴栨槸鐢↗DK宸叉湁鐨娓叉煋鍣ㄤ篃鍙互锛2銆侀噸鍐TableModel鐨刧etColumnClass 鍙傝冨疄渚嬪涓嬶細public class Test { public static void main(String[] args) { String[][] cells = new String[6][7];String add = "1";//宸茬粡瀛樺湪鐨勫彉閲 int addValue = Integer.parseInt(add...
绛旓細import javax.swing.*;import javax.swing.table.*;import java.util.*;public class JTable_main extends JFrame { private int rows=3, cols=5;private Object[] rowData = new Object[cols];private DefaultTableModel model = new DefaultTableModel();private JTable table = new JTable(...
