java图像开发学习——JTable之导入数据库

package demo;
import java.awt.BorderLayout;
import java.awt.Container;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.awt.event.MouseListener;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.Vector;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
public class DeMO {
public DeMO(){
JFrame frame=new JFrame("暮雪超霸");
Container contentPane = frame.getContentPane();
JPanel panel=new JPanel();
JPanel panel1=new JPanel();
JPanel panel2=new JPanel();
JLabel jLabel=new JLabel("超霸");
JButton button=new JButton("开始");
JButton button2=new JButton("暂停");
JButton button3=new JButton("下一首");
contentPane.setLayout(new BorderLayout());
panel.add(jLabel);
panel.add(button);
panel.add(button2);
panel.add(button3);
contentPane.add(panel,BorderLayout.NORTH);
JButton button4=new JButton("退出");
Conn con=new Conn();
ResultSet select = con.getSelect("select *from chaoba");
Vector col = getCol(select);
Vector data = getData(select);
JTable jTable=new JTable(data,col);
JScrollPane jScrollPane=new JScrollPane();
jScrollPane.getViewport().add(jTable);
panel1.add(button4);
panel2.add(jScrollPane);
contentPane.add(panel1,BorderLayout.SOUTH);
contentPane.add(panel2,BorderLayout.CENTER);
frame.setSize(600, 400);
frame.setVisible(true);
button.addMouseListener(new MouseAdapter() {
@Override
public void mouseClicked(MouseEvent arg0) {
System.out.println("开始");
}
});
button2.addMouseListener(new MouseAdapter() {
@Override
public void mouseClicked(MouseEvent arg0) {
System.out.println("暂停");
}
});
}
public static void main(String[] args) {
    new DeMO();
}
public Vector getCol(ResultSet rs){
Vector col=new Vector();
try {
ResultSetMetaData metaData = rs.getMetaData();
int columnCount = metaData.getColumnCount();
for (int i = 1; i <= columnCount; i++) {
col.add(metaData.getColumnName(i));
}
} catch (Exception e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
return col;
}
public Vector getData(ResultSet rs){
Vector data=new Vector();
try {
ResultSetMetaData metaData = rs.getMetaData();
int columnCount = metaData.getColumnCount();
while (rs.next()) {
Vector v=new Vector();
for(int i=1;i<=columnCount;i++)
{
v.addElement(rs.getString(i));
}
data.addElement(v);
}
} catch (SQLException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
return data;
}
}

package demo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;
public class Conn {
Connection con;
public  Conn(){
try {
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/chaoba?user=root&password=root&useUnicode=true&characterEncoding=UTF8";
 con=DriverManager.getConnection(url);
} catch (Exception e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
}
public ResultSet getSelect(String sql){
Vector col=new Vector();
Vector data=new Vector();
ResultSet rs=null;
Statement statement;
try {
statement = con.createStatement();
 rs = statement.executeQuery(sql);
} catch (SQLException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
return rs;
}
}

java图像开发学习——JTable之导入数据库

标签：ram   char   url   ane   resultset   listener   package   tab   string