Java图形化界面访问数据库技术

Java图形化界面访问数据库技术

一、实验目的
1、熟悉JDBC常用API
2、掌握数据库联接、更新等操作

Java图形化界面设计代码:
JTextField jid = new JTextField(10);
JTextField jname = new JTextField(10);
JTextField jsex = new JTextField(10);
JTextField jshanchu = new JTextField(10);
JTextField j_id = new JTextField(10);
JTextField j_name = new JTextField(10);
JButton btn = new JButton(“确认添加”);
JButton btn1 = new JButton(“删除信息”);
JButton btn3 = new JButton(“删除一个人”);
JButton btn4 = new JButton(“查询数据库”);

初始化数据库的内容，连接JDBC
public class DataBase {
Connection conn=null;
Statement st=null;
public void Connect ()throws
SQLException,java.lang.ClassNotFoundException{
try {
Class.forName(“com.mysql.jdbc.Driver”);
String url=“jdbc:mysql://localhost:3306/test”;
String user=“root”;
String password=“123”;
conn=DriverManager.getConnection(url, user, password);
System.out.println(“链接数据库成功！”);
}catch (Exception e){
System.out.println(“链接数据库失败！”);
System.out.println(e.getMessage());
}
}

对数据实现信息添加:
public void addPerson(int id,String name,String sex) throws SQLException {
st=conn.createStatement();
st.executeUpdate(“insert into person” +
" values ("+id+",’"+name+"’,’"+sex+"’)");
System.out.println(“添加信息成功！”);
}

对数据实现信息删除:
public void delPerson(int id) throws SQLException {
st=conn.createStatement();
String sql1 = “delete from person “+” where id= '”+id+"’; ";
st.executeUpdate(sql1);
System.out.println(“删除信息成功”);
}

对数据实现信息查询
public void queryPerson(){
try{
st=conn.createStatement();
String StrSQL=“select * from person”;
ResultSet rs=st.executeQuery(StrSQL);
System.out.println(“person表的数据如下：”);
System.out.println("----------------！");
System.out.println("–编号"+" --姓名"+"–性别");
System.out.println("-------------------");
while (rs.next()){
String id = String.valueOf(rs.getInt(“id”));
String name = rs.getString(“name”);
String sex = rs.getString(“sex”);
System.out.println("–"+id+" --"+name+"–"+sex);
}
}catch (SQLException e){
System.out.println(“加载失败！”);
System.out.println(e.getMessage());
}
}

对数据库实现信息修改
public void xiugai(int id,String name){
try {
st=conn.createStatement();
String sql1 = “update person set name=? where id=?”;
PreparedStatement ps = conn.prepareStatement(sql1);
ps.setInt(2,id);
ps.setString(1,name);
ps.executeUpdate();
System.out.println(“修改成功”);
} catch (SQLException e) {
e.printStackTrace();
}
}
**完整代码:
public class DataBase extends JFrame {
Connection conn=null;
Statement st=null;
private JLabel mJLabel;
public DataBase(){
setTitle(“test1”);
setSize(500,500);
setVisible(true);
setLayout(new FlowLayout());
JTextField jid = new JTextField(10);
JTextField jname = new JTextField(10);
JTextField jsex = new JTextField(10);
JTextField jshanchu = new JTextField(10);
JTextField j_id = new JTextField(10);
JTextField j_name = new JTextField(10);
JTable jTable = new JTable();
JButton btn = new JButton(“确认添加”);
JButton btn1 = new JButton(“删除信息”);
JButton btn3 = new JButton(“删除一个人”);
JButton btn4 = new JButton(“查询数据库”);
JButton btn5 = new JButton(“修改数据库”);
JButton btn2 = new JButton(“结束数据库”);
mJLabel = new JLabel();
btn.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
try {
if (!jid.getText().toString().equals("")&&!jname.getText().toString().equals("")&&!jsex.getText().toString().equals("")){
addPerson(Integer.parseInt(jid.getText().toString()),jname.getText().toString(),jsex.getText().toString());
}
} catch (SQLException ex) {
ex.printStackTrace();
}
}
});
btn1.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
if (!jshanchu.equals("")){
try {
delPerson(Integer.parseInt(jshanchu.getText().toString()));
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
});
btn2.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
close_connection();
}
});
btn3.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
try {
delOnePerson();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
});
btn4.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
queryPerson();
}
});
btn5.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
if (!j_id.getText().equals("")&&!j_name.getText().equals("")){
xiugai(Integer.parseInt(j_id.getText().toString()),j_name.getText().toString());
}
}
});
add(jid);
add(jname);
add(jsex);
add(btn);
add(jshanchu);
add(btn1);
add(btn3);
add(btn2);
add(btn4);
add(j_id);
add(j_name);
add(btn5);
}
public void Connect ()throws SQLException,java.lang.ClassNotFoundException{
try {
Class.forName(“com.mysql.jdbc.Driver”); //版本
String url=“jdbc:mysql://localhost:3306/test8”; //地址
String user=“root”; //用户名
String password=“root”; //密码
conn= DriverManager.getConnection(url, user, password);
System.out.println(“链接数据库成功！”);
}catch (Exception e){
System.out.println(“链接数据库失败！”);
System.out.println(e.getMessage());
}
}
public void addPerson(int id,String name,String sex) throws SQLException {
st=conn.createStatement();
st.executeUpdate(“insert into person” +
" values ("+id+",’"+name+"’,’"+sex+"’)");
System.out.println(“添加信息成功！”);
}
public void delPerson(int id) throws SQLException {
st=conn.createStatement();
String sql1 = “delete from person “+” where id= '”+id+"’; “;
st.executeUpdate(sql1);
System.out.println(“删除信息成功”);
}
public void delOnePerson() throws SQLException {
st=conn.createStatement();
String StrSQL=“select * from person”;
ResultSet rs=st.executeQuery(StrSQL);
while (rs.next()){
String id = String.valueOf(rs.getInt(“id”));
String sql1 = “delete from person “+” where id= '”+id+”’; “;
st.executeUpdate(sql1);
break;
}
System.out.println(“删除成功”);
}
public void queryPerson(){
try{
st=conn.createStatement();
String StrSQL=“select * from person”;
ResultSet rs=st.executeQuery(StrSQL);
System.out.println(“person表的数据如下：”);
System.out.println(”----------------！");
System.out.println("–编号"+" --姓名"+"–性别");
System.out.println("-------------------");
while (rs.next()){
String id = String.valueOf(rs.getInt(“id”));
String name = rs.getString(“name”);
String sex = rs.getString(“sex”);
System.out.println("–"+id+" --"+name+"–"+sex);
}
}catch (SQLException e){
System.out.println(“加载失败！”);
System.out.println(e.getMessage());
}
}
public void xiugai(int id,String name){
try {
st=conn.createStatement();
String sql1 = “update person set name=? where id=?”;
PreparedStatement ps = conn.prepareStatement(sql1);
ps.setInt(2,id);
ps.setString(1,name);
ps.executeUpdate();
System.out.println(“修改成功”);
} catch (SQLException e) {
e.printStackTrace();
}
}
public void close_connection(){
try {
st.close();
conn.close();
System.out.println(“数据库关闭成功！”);
}catch (Exception e){
System.out.println(“数据库失败！”);
System.out.println(e.getMessage());
}
}
public static void main(String[] args) {
DataBase d = new DataBase();
}
}