Java连接数据库增删改查.doc
文本预览下载声明
Java连接sql2000数据库增删改查功能
学院：仲恺农业工程学院 姓名：陈伟团 专业：计算机科学与技术 班级：084班
1. 数据库连接
package edu;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBConnection {
public static Connection getConnection({
Connection conn = null;
String driver = com.microsoft.jdbc.sqlserver.SQLServerDriver;
String url = jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=shop;
String username = sa;
String password = sa;
try {
Class.forName(driver;
conn = DriverManager.getConnection(url,username,password;
} catch (ClassNotFoundException e {
e.printStackTrace(;
} catch (SQLException e {
e.printStackTrace(;
}
return conn;
}
2. 生成get set方法
package edu;
public class Country {
private String name;
private String region;
private String area;
private String population;
private String gdp;
public String getName( {
return name;
}
public void setName(String name {
this.name = name;
}
public String getRegion( {
return region;
}
public void setRegion(String region {
this.region = region;
}
public String getArea( {
return area;
}
public void setArea(String area {
this.area = area;
}
public String getPopulation( {
return population;
}
public void setPopulation(String population {
this.population = population;
}
public String getGdp( {
return gdp;
}
public void setGdp(String gdp {
this.gdp = gdp;
}
}
3实现方法
package edu;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.List;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.SwingUtilities;
public class CountryInfoGui implements ActionListener {
private JFrame jFrame;
private JPanel jContentPane;
private JLabel lblName = null;
private JTextField tfName = null;
private JLabel lblRegion = null;
private JComboBox cbRegion =
显示全部