数据库
这个是主类
package ce;
import java.awt.EventQueue;
import java.util.List;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
import javax.swing.JScrollPane;
import javax.swing.border.TitledBorder;
import javax.swing.border.BevelBorder;
import javax.swing.UIManager;
import javax.swing.JButton;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
public class text {
private JFrame frame;
private JScrollPane scrollPane;
private JTable table;
/**
* Launch the application.
*/
public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
public void run() {
try {
text window = new text();
window.frame.setVisible(true);
} catch (Exception e) {
e.printStackTrace();
}
}
});
}
/**
* Create the application.
*/
public text() {
initialize();
}
/**
* Initialize the contents of the frame.
*/
private void initialize() {
frame = new JFrame();
frame.setTitle("\u4F1A\u5458\u5361\u7BA1\u7406\u7CFB\u7EDF");
frame.setBounds(100, 100, 844, 512);
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
frame.getContentPane().setLayout(null);
cha ca = new cha();
List<EMP>arr = ca.query();
String[] name = new String[] {
"序号", "手机", "姓名","性别","办卡日期","卡余额"
};
String[][]s1 = new String[arr.size()][6];
for(int i=0;i<arr.size();i++) {
EMP e =arr.get(i);
int num=e.getMemberID();
for(int j=i;j<s1.length;j++) {
s1[j][0]=num+"";
s1[j][1]=e.getPhone();
s1[j][2]=e.getName();
s1[j][3]=e.getSex();
s1[j][4]=e.getOpenDate();
s1[j][5]=e.getBalance()+"";
}
}
JButton btnNewButton = new JButton("\u67E5\u8BE2");
btnNewButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
cha ca = new cha();
List<EMP>arr = ca.query();
String[] name = new String[] {
"序号", "手机", "姓名","性别","办卡日期","卡余额"
};
String[][]s1 = new String[arr.size()][6];
for(int i=0;i<arr.size();i++) {
EMP ea =arr.get(i);
int num=ea.getMemberID();
for(int j=i;j<s1.length;j++) {//循环放进表格
s1[j][0]=num+"";
s1[j][1]=ea.getPhone();
s1[j][2]=ea.getName();
s1[j][3]=ea.getSex();
s1[j][4]=ea.getOpenDate();
s1[j][5]=ea.getBalance()+"";
}
}
table.setModel(new DefaultTableModel(
s1,
name
));
}
});
btnNewButton.setBounds(456, 28, 93, 23);
frame.getContentPane().add(btnNewButton);
JButton btnNewButton_1 = new JButton("\u5220\u9664");
btnNewButton_1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
shan san = new shan();
int s1 =JOptionPane.showConfirmDialog(null, "确定要删除吗?");
if(s1==0) {
}
}
});
btnNewButton_1.setBounds(635, 28, 93, 23);
frame.getContentPane().add(btnNewButton_1);
scrollPane = new JScrollPane();
scrollPane.setBounds(64, 75, 711, 344);
frame.getContentPane().add(scrollPane);
table = new JTable();
table.setModel(new DefaultTableModel(
s1,
name
));
scrollPane.setViewportView(table);
}
}
删除方法 暂时还没实现删除功能,因为不知道怎么删除表格行
package ce;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class shan {
public boolean delet(int Id) {//删
Connection conn =mysql.getConnection();
String sql="delete from text where memberid = ?";
PreparedStatement pStat=null;
try {
//获取Prapared对象
pStat = conn.prepareStatement(sql);
//将?用预处理的方式替换成你要的数据 1表示第一个占位符
pStat.setInt(1, Id);
return pStat.executeUpdate()>0?true:false;
} catch (SQLException e) {
e.printStackTrace();
}
finally {
try {
if(pStat!=null) {
pStat.close();
}
if(conn!=null) {
conn.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
return false;
}
}
数据库链接驱动
package ce;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.util.Scanner;
import dbconnectiondemo.DbConnection;
import dbconnectiondemo.Dbsixsixsix;
public class mysql {
private static final String DRIVERNAME = "com.mysql.jdbc.Driver";
private static final String URL="jdbc:mysql://localhost:3306/memberdb";
//数据库登录账号
private static final String USER="root";
//数据库登录密码
private static final String PASSWORD="12345678";
static {
try {
Class.forName(DRIVERNAME);
} catch (Exception e) {
e.printStackTrace();
}
}
public static Connection getConnection() {
Connection conn=null;
try {
return DriverManager.getConnection(URL,USER,PASSWORD);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
public static void main(String[] args) {
Connection conn= getConnection();
System.out.println(conn);
}
}
EMP 方法类
package ce;
public class EMP {
public int getMemberID() {
return memberID;
}
public void setMemberID(int memberID) {
this.memberID = memberID;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getOpenDate() {
return openDate;
}
public void setOpenDate(String openDate) {
this.openDate = openDate;
}
public double getBalance() {
return balance;
}
public void setBalance(double balance) {
this.balance = balance;
}
private int memberID;//会员编号
private String phone;//会员手机
private String name;//会员姓名
private String sex;//性别
private String openDate;//办卡日期
private double balance;//卡内余额
}
查询数据库全部内容并且放进数组 返回放进表格
package ce;
import java.lang.annotation.Retention;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.*;
import text.Main;
public class cha {
public List<EMP> query(){
ArrayList<EMP>arr=new ArrayList<EMP>();
Connection conn = mysql.getConnection();
String sql ="select * from members";
PreparedStatement pStat=null;
ResultSet res=null;
try {
pStat = conn.prepareStatement(sql);
res= pStat.executeQuery();
while(res.next()) {
int memberID =res.getInt("memberID");
String phone = res.getString("phone");
String name = res.getString("name");
String sex = res.getString("sex");
String openDate = res.getString("openDate");
double balance = res.getDouble("balance");
EMP emp = new EMP();
emp.setMemberID(memberID);
emp.setPhone(phone);
emp.setBalance(balance);
emp.setName(name);
emp.setSex(sex);
emp.setOpenDate(openDate);
arr.add(emp);
}
} catch (Exception e) {
e.printStackTrace();
}
finally {
try {
if(res!=null) {
res.close();
}
if(pStat!=null) {
pStat.close();
}
if(conn!=null) {
conn.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
return arr;
}
public static void main(String[] args) {
cha ca = new cha();
List<EMP>arr = ca.query();
for(int i=0;i<arr.size();i++) {
EMP e =arr.get(0);
System.out.println(e.getBalance()+" "+e.getMemberID()+" "+e.getName());
}
}
}