java实验报告五.doc
文本预览下载声明
java实验报告五
篇一:java实验报告五5
天津理工大学实验报告
学院(系)名称:计算机与通信工程学院
源程序:
工具类:
package Homework;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBUtil {
private static String driver;
private static String url;
private static String username;
private static String password;
static{
driver=quot;com.mysql.jdbc.Driverquot;;
url=quot;jdbc:mysql://localhost:3306/mydb?useUnicode=trueamp;characterEncoding=UTF-8 quot;;
username=quot;rootquot;;
password=null;
}
public static Connection open(){
try {
Class.forName(driver);
return DriverManager.getConnection(url,username,password);} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
public static void close(Connection conn){
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
Student类,里面包含数据库的列和set和get方法
package Homework;
public class Student {
int id;
public int getId() {
} public void setId(int id) { } String name; this.id = id;
String sex;
int number;
int account;
String college;
public String getName() { } public void setName(String name) { } public String getSex() { } public void setSex(String sex) { } public int getNumber() { } public void setNumber(int number) { } public int getAccount() { } public void setAccount(int account) { } public String getCollege() { } public void setCollege(String college) { } @Override public String toString() {}
return name; = name; return sex; this.sex = sex; return number; this.number = number; return account; this.account = account; return college; this.college = college; // TODO Auto-generated method stub return name+quot;-quot;+sex+quot;-quot;+number+quot;-quot;+account+quot;quot;+college;
Example类:创建一个简单的界面,使用的是BorderLayout布局,然后实现增 删 改 查。
package Homework;
import java.awt.BorderLayout;
import java.awt.Component;
import java.awt.FlowLayout;
import java.awt.ev
显示全部