以前的代码,现在重新贴出来。。
1 Datebase.java 数据库的基本连接,下面几个java文件都用到,所以写成一个java文件。
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class Datebase {
public static Connection openconn() {
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost/test?characterEncoding=UTF-8";
String user = "root";
String password = "";
conn = DriverManager.getConnection(url, user, password);
if (conn != null) {
System.out.println("连接成功");
}
} catch (SQLException e) {
System.out.println("连接失败");
} catch (ClassNotFoundException e) {
System.out.println("驱动程序导入失败");
}
return conn;
}
public static void closeconn(PreparedStatement ptml, Connection conn) {
if (ptml != null) {
try {
ptml.close();
if (conn != null) {
conn.close();
}
System.out.println("数据库关闭成功");
} catch (SQLException e) {
System.out.println("关闭失败");
}
}
}
public static void main(String[] args) {
openconn();
}
}
Demo1.java 数据库的添加操作
import java.sql.Connection;
import java.sql.PreparedStatement;
public class Demo1 {
private static Datebase conn = new Datebase();
// private static Student stu = new Student();
public static int add(Student stu) throws Exception {
Connection conn = Datebase.openconn();
String sql = "insert into gdmec values(?,?,?,?)";
PreparedStatement ptml = conn.prepareStatement(sql);
ptml.setString(1, stu.getId());
ptml.setString(2, stu.getName());
ptml.setInt(3, stu.getAge());
ptml.setString(4, stu.getClassName());
int result = ptml.executeUpdate();
Datebase.closeconn(ptml,conn);
return result;
}
public static void main(String[] args) throws Exception {
Student stu = new Student("as", "ss", 12, "55");
int result = add(stu);
if (result == 1) {
System.out.println("添加成功!");
} else {
System.out.println("添加失败!");
}
}
}
Demo2.java 数据库修改操作
import java.sql.Connection;
import java.sql.PreparedStatement;
public class Demo2 {
private static Datebase conn = new Datebase();
public static int update(Student stu) throws Exception {
Connection conn = Datebase.openconn();
String sql = "update gdmec set id=?,name=?,age=?,className=? where id='as'";
PreparedStatement ptml = conn.prepareStatement(sql);
ptml.setString(1, stu.getId());
ptml.setString(2, stu.getName());
ptml.setInt(3, stu.getAge());
ptml.setString(4, stu.getClassName());
//ptml.setString(5, stu.getId());
int result=ptml.executeUpdate();
Datebase.closeconn(ptml,conn);
return result;
}
public static void main(String[] args) throws Exception {
Student stu = new Student("11", "ss", 12, "66");
int result = update(stu);
if (result >= 1) {
System.out.println("修改成功!");
} else {
System.out.println("修改失败!");
}
}
}
Demo3.jvav 数据库删除操作
import java.sql.Connection;
import java.sql.PreparedStatement;
public class Demo3 {
private static Datebase conn = new Datebase();
public static int delete(String id)throws Exception{
Connection conn = Datebase.openconn();
String sql = "delete from gdmec where id=?";
PreparedStatement ptml = conn.prepareStatement(sql);
ptml.setString(1, id);
int result = ptml.executeUpdate();
Datebase.closeconn(ptml,conn);
return result;
}
public static void main(String[] args) throws Exception{
int result = delete("11");
if (result >= 1) {
System.out.println("删除成功!");
} else {
System.out.println("删除失败!");
}
}
}
Demo4.java 数据库查询操作
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
public class Demo4 {
private static Datebase conn = new Datebase();
public static List<Student> select() throws Exception {
List<Student> list = new ArrayList<Student>();
Connection conn = Datebase.openconn();
String sql = "select * from gdmec";
PreparedStatement ptml = conn.prepareStatement(sql);
ResultSet rs = ptml.executeQuery();
while (rs.next()) {
String id = rs.getString("id");
String name = rs.getString("name");
int age = rs.getInt("age");
String className = rs.getString("className");
Student stu = new Student(id, name, age, className);
list.add(stu);
}
return list;
}
public static void main(String[] args) throws Exception {
List<Student> list = select();
for (Student student : list) {
System.out.println(list);
}
}
}
Student.java student类的基本信息
public class Student {
private String id;
private String name;
private int age;
private String className;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public String getClassName() {
return className;
}
public void setClassName(String className) {
this.className = className;
}
public Student() {
super();
// TODO Auto-generated constructor stub
}
public Student(String id, String name, int age, String className) {
super();
this.id = id;
this.name = name;
this.age = age;
this.className = className;
}
@Override
public String toString() {
return "["+this.id + "," + this.name + ","+ this.age + ","+ this.className+"]";
}
}