简单的连接数据库增删改查(1)

}
@Override
public String getColumnName(int column) {
// TODO Auto-generated method stub
return ((String)this.columnnNames.get(column));
}
}
// TODO Auto-generated method stub
return this.columnnNames.size();
}
//返回该模型的行数
@Override
public int getRowCount() {
// TODO Auto-generated method stub
return this.rowDate.size();
}
//返回该模型的的具体行的只和列的值
@Override
public Object getValueAt(int rowIndex, int columnIndex) {
// TODO Auto-generated method stub
return ((Vector)this.rowDate.get(rowIndex)).get(columnIndex);
}
columnnNames = new Vector();
//设置列
columnnNames.add("学号");
columnnNames.add("姓名");
columnnNames.add("性别");
columnnNames.add("年龄");
columnnNames.add("籍贯");
columnnNames.add("系别");
hang.add(rs.getString(3));
hang.add(rs.getInt(4));
hang.add(rs.getString(5));
hang.add(rs.getString(6));
rowDate.add(hang);
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
//有参的构造方法
public Mxstu(String sql) {
this.Showsql(sql);
}
//无参的构造方法
public Mxstu() {
this.Showsql("");
}
//返回该模型的列数
@Override
public int getColumnCount() {
package com.suqin.Tank2;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Vector;
//连接数据库
Connection conn;
//执行sql语句
PreparedStatement pst;
//集合级
ResultSet rs;
//驱动程序
public String Driver = "com.mysql.jdbc.Driver";
//连接地址mysql数据库名称
public String Url = "jdbc:mysql://127.0.0.1:3306/mysql";
import javax.swing.JScrollPane;
import javax.swing.table.AbstractTableModel;
public class Mxstu extends AbstractTableModel {
//集合
Vector rowDate, columnnNames;
//用户名
public String name = "root";
//用户密码
public String password = "admin";
//sql语句
String sql;
public void Showsql(String sql) {
if (sql=="") {
sql="select * from students";
pst = conn.prepareStatement(sql);
//得到结果集合
rs = pst.executeQuery();
//得到记录
while (rs.next()) {
//设置行
Vector hang = neFra Baidu bibliotek Vector();
hang.add(rs.getInt(1));
hang.add(rs.getString(2));
//设置行内容
rowDate = new Vector();
//夹在驱动程序
try {
Class.forName(Driver);
conn = DriverManager.getConnection(Url, name, password);
//执行语句
//sql = ("select * from students");