一些基础的关于java jdbc的程序代码
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;