连接数据库

 

import java.awt.Container;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Vector;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;

public class Test extends JFrame implements ActionListener{

 JLabel labid,labname,labsex,labbirthday,labdescp;
 JTextField jtfid,jtfname,jtfsex,jtfbirthday,jtfdescp;
 JButton btninsert, btnupdate,btndelete;
 
 Container cont;
 
 public Test(){
  super("增删改查");
  labid = new JLabel("编    号：");
  labname = new JLabel("名    称：");
  labsex = new JLabel("性    别：");
  labbirthday = new JLabel("出生日期：");
  labdescp = new JLabel("其他描述：");
  
  
  jtfid = new JTextField(15);
  jtfname = new JTextField(15);
  jtfsex = new JTextField(15);
  jtfbirthday = new JTextField(15);
  jtfdescp = new JTextField(15);
  Vector vname = new Vector();
  vname.add("id");
  vname.add("name");
  vname.add("sex");
  vname.add("brithday");
  vname.add("descp");
  Vector vdata = new DManager().getAllData("select * from petinfo");
  JTable tab = new JTable(vdata,vname);
  JScrollPane jsp = new JScrollPane(tab);
  
  btninsert = new JButton("插入");
  btninsert.addActionListener(this);
  btnupdate = new JButton("修改");
  btnupdate.addActionListener(this);
  btndelete = new JButton("删除");
  btndelete.addActionListener(this);
  
  cont = this.getContentPane();
  cont.setLayout(new FlowLayout());
  cont.add(labid);
  cont.add(jtfid);
  cont.add(labname);
  cont.add(jtfname);
  cont.add(labsex);
  cont.add(jtfsex);
  cont.add(labbirthday);
  cont.add(jtfbirthday);
  cont.add(labdescp);
  cont.add(jtfdescp);
  cont.add(jsp);
  cont.add(btninsert);
  cont.add(btnupdate);
  cont.add(btndelete);
  
  this.setVisible(true);
  this.setSize(500,600);
  this.validate();
  
 }
 public static void main(String[] args) {
  // TODO Auto-generated method stub

  new Test();
 }
 public void actionPerformed(ActionEvent e) {
  if(e.getSource()==btninsert){
   int petid = Integer.parseInt(jtfid.getText());
   String petname = jtfname.getText();
   String petsex = jtfsex.getText();
   String petbrithday = jtfbirthday.getText();
   String beizhu = jtfdescp.getText();
   
                        //执行查询
   String sql = "insert into petinfo values ("+petid +",'"+petname + "','"+ petsex + "','"+petbrithday + "','"+ beizhu + "')";
   
   DManager db = new DManager();
   int num = db.optionData(sql);
   if(num>0){  
    JOptionPane.showConfirmDialog(null, "插入成功");
    dispose();
    new Test();//身份正确，转到另外一个网页
    
   }
   else{     
    JOptionPane.showConfirmDialog(null, "插入失败");
   }
  }
  if(e.getSource()==btndelete){
   int id = Integer.parseInt(jtfid.getText());
   
   String sql = "delete from petinfo where petid = "+ id;
   int num = new DManager().optionData(sql);
   if(num>0){
    JOptionPane.showConfirmDialog(null, "删除成功");
    
   }
   else{
    JOptionPane.showConfirmDialog(null, "删除失败");
   }
  }
  
 }

}

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

-----------------------------------------------------------------------------------
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;

public class DManager {
        //建立数据库连接并执行数据插入
 Connection conn;
 Statement stat;
 ResultSet rs;
 
 static{ //加载驱动
  try {
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  } catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 }
 public static Connection getConn(){
  Connection con=null;
  try {
   con = DriverManager.getConnection("jdbc:odbc:driver={sql server};server=.;database=pets;uid=sa;pwd=");
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return con;
 }
 public Vector getAllData(String sql){
  Vector v = new Vector();
  conn = DManager.getConn();
  try {
   stat = conn.createStatement();
   rs = stat.executeQuery(sql);
   while(rs.next()){
    Vector vect = new Vector();
    vect.add(rs.getInt("petid"));
    vect.add(rs.getString("petname"));
    vect.add(rs.getString("petsex"));
    vect.add(rs.getString("petbrithday"));
    vect.add(rs.getString("beizhu"));
    v.add(vect);
   }
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return v;
 }
 public int optionData(String sql){
  int num = 0;
  conn = DManager.getConn();
  try {
   stat = conn.createStatement();
   num = stat.executeUpdate(sql);
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return num;
 }
 public static void main(String[] args) {
  // TODO Auto-generated method stub

 }

}