补补补补1月TAT

回想起1月的事情，最让我印象深刻又痛苦的当然是JAVA最后的大作业了

枉我悬赏100圆豆都解决不了问题桑心

废话不多说，我绝对不承认我是在凑字数，~\(≧▽≦)/~啦啦啦

下面是正题

写了2个包，一个是Main 一个是Swing

Main里面只有2个java，一个是与数据库建立连接的，一个是主界面运行的

//Main.java

public class Main
{

public static void main(String[] args)
{

}

//DBlink.java

package Main;

import java.sql.Connection;
import java.sql.DriverManager;

public class DBlink
{

public Connection con=null;

public DBlink()
{
String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL="jdbc:sqlserver://localhost:1434;DatabaseName=BusSystem";
String userName="sa"; //默认用户名
String userPwd="000000"; //密码
try{
Class.forName(driverName);
con=DriverManager.getConnection(dbURL,userName,userPwd);
System.out.println("连接成功！"); //如果连接成功，控制台输出“连接成功！”
}catch(Exception e)
{
System.out.println("连接失败！");
e.printStackTrace();
}

}
}

接下来是Swing包里的内容

图形界面还是挺容易搭建的，感觉和画图出不多，= =

关键是写好监听器就好了，当然这个也挺容易的

eg：

JButton button_2 = new JButton();//一个button
button_2.addMouseListener(new MouseAdapter() {
@Override
public void mouseClicked(MouseEvent arg0) //鼠标点击时完成的动作
{
JOptionPane.showMessageDialog(null, "感谢您的使用！", "对话框",
JOptionPane.PLAIN_MESSAGE);//显示对话框，提示感谢您的使用
System.exit(0);//退出系统
}
});
button_2.setText("\u9000\u51FA");//退出的文本

当然还有窗口的显示和隐藏

setVisible(false);//当前窗口的隐藏
Window lo = new Window();
lo.setLocationRelativeTo(null);//在屏幕正中间显示
lo.setVisible(true);//新窗口的显示

到了最蛋疼的部分，TAT

就是与数据库连接后对数据进行查询，添加，删除，修改，并显示在Jtable的表格里

//查询

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {

sp = "bus";

String[] data = new String[6];

DBlink a = new DBlink();

PreparedStatement p = null;//命令对象

ResultSet rs = null;//结果集对象

String s[] = { "NUMBER", "TYPE", "ENGINE NUMBER", "SEATING CAPACITY", "ROUTE", "AD" };

String sql = "select * from bus";

DefaultTableModel model = (DefaultTableModel) this.jTable1.getModel();

int numT;//表格已有数据的行数

numT = model.getRowCount();//获取当前已有行数

while (numT > 0) //如果是全体刷新表格需要移除之前的所有数据行

{

model.removeRow(0);

numT--;

}

int i;

for (i = 0; i < s.length; i++) {

model.setColumnIdentifiers(s);

}

try {

p = a.con.prepareStatement(sql);//命令对象

rs = p.executeQuery();

while (rs.next()) {

data[0] = rs.getString("number").trim();

data[1] = rs.getString("type").trim();

data[2] = rs.getString("engine_numbe").trim();

data[3] = rs.getString("seating_capacity").trim();

data[4] = rs.getString("route").trim();

data[5] = rs.getString("ad").trim();

model.addRow(data);

}

jTable1.setModel(model);//将修改后的model传回给JTable*

a.con.close();

p.close();

rs.close();

} catch (SQLException e) {

e.printStackTrace();

}

//添加

public void add() {

DBlink a = new DBlink();

PreparedStatement p = null;//命令对象

try {

this.number=Integer.parseInt(jTextField6.getText());

this.type = jTextField1.getText();

this.engine_numbe = Integer.parseInt(jTextField2.getText());

this.seating_capacity = Integer.parseInt(jTextField3.getText());

this.route = Integer.parseInt(jTextField4.getText());

this.ad = jTextField5.getText();

} catch (NumberFormatException e) {

JOptionPane.showMessageDialog(null, "输入数据格式错误！", "错误",

JOptionPane.WARNING_MESSAGE);

return;

}

Object[] value = { "是", "否", "取消" };

int result = JOptionPane.showOptionDialog(null, "确定添加", "警告", 2, 2,

null, value, value[0]);

if (result == 0) {

String sql2 = "insert into bus(number,type,engine_numbe,seating_capacity,route,ad) values(?,?,?,?,?,?)";

try {

p = a.con.prepareStatement(sql2);//命令对象

p.setInt(1, number);

p.setString(2, type);

p.setInt(3, engine_numbe);

p.setInt(4, seating_capacity);

p.setInt(5, route);

p.setString(6, ad);

p.execute();

JOptionPane.showMessageDialog(null, "添加成功");

a.con.close();

p.close();

} catch (SQLException e) {

//JOptionPane.showMessageDialog(null, "数据库连接错误！", "错误",

// JOptionPane.WARNING_MESSAGE);

}

catch (NumberFormatException e) {

JOptionPane.showMessageDialog(null, "输入数据格式错误！", "错误",

JOptionPane.WARNING_MESSAGE);

}

refresh();

}

//修改

public void update() {

DBlink a = new DBlink();

PreparedStatement p = null;//命令对象

ResultSet rs = null;//结果集对象

try {

this.number = Integer.parseInt(jTextField6.getText());

this.type = jTextField1.getText();

this.engine_numbe = Integer.parseInt(jTextField2.getText());

this.seating_capacity = Integer.parseInt(jTextField3.getText());

this.route = Integer.parseInt(jTextField4.getText());

this.ad = jTextField5.getText();

} catch (NumberFormatException e) {

JOptionPane.showMessageDialog(null, "输入数据格式错误！", "错误",

JOptionPane.WARNING_MESSAGE);

return;

}

Object[] value = { "是", "否", "取消" };

int result = JOptionPane.showOptionDialog(null, "确定修改此", "警告", 2, 2,

null, value, value[0]);

if (result == 0) {

String sql1 = "select * from bus where number=?";

String sql2 = "update bus set type=?,engine_numbe=?,seating_capacity=?,route=?,ad=? where number=?";

try {

p = a.con.prepareStatement(sql1);//命令对象

p.setInt(1, number);

rs = p.executeQuery();

if (rs.next() && rs.getRow() > 0) {

p = a.con.prepareStatement(sql2);//命令对象

p.setString(1, type);

p.setInt(2, engine_numbe);

p.setInt(3, seating_capacity);

p.setInt(4, route);

p.setString(5, ad);

p.setInt(6, number);

p.execute();

} else {

JOptionPane.showMessageDialog(null, "不存在您要修改的车辆不存在", "错误",

JOptionPane.WARNING_MESSAGE);

}

a.con.close();

p.close();

rs.close();

} catch (SQLException e) {

JOptionPane.showMessageDialog(null, "数据库连接错误！", "错误",

JOptionPane.WARNING_MESSAGE);

} catch (NumberFormatException e) {

JOptionPane.showMessageDialog(null, "输入数据格式错误！", "错误",

JOptionPane.WARNING_MESSAGE);

}

refresh();

}

//删除

public void delete() {

jTextField1.setEditable(true);

DBlink a = new DBlink();

PreparedStatement p = null;//命令对象

ResultSet rs = null;//结果集对象

try {

this.number = Integer.parseInt(jTextField6.getText());

} catch (NumberFormatException e) {

JOptionPane.showMessageDialog(null, "输入数据格式错误！", "错误",

JOptionPane.WARNING_MESSAGE);

return;

}

if (jTextField1.equals(null)) {

JOptionPane.showMessageDialog(this, "序号不能为空", "错误",

JOptionPane.WARNING_MESSAGE);

return;

}

Object[] value = { "是", "否", "取消" };

int result = JOptionPane.showOptionDialog(null, "确定删除此", "警告", 2, 2,

null, value, value[0]);

if (result == 0) {

String sql1 = "select * from bus where number=?";

String sql2 = "delete from bus where number=?";

try {

p = a.con.prepareStatement(sql1);//命令对象

p.setInt(1, number);

rs = p.executeQuery();

if (rs.next() && rs.getRow() > 0) {

p = a.con.prepareStatement(sql2);//命令对象

p.setInt(1, number);

p.execute();

JOptionPane.showMessageDialog(null, "删除成功！");

} else {

JOptionPane.showMessageDialog(null, "不存在您要删除的车辆", "错误",

JOptionPane.WARNING_MESSAGE);

}

a.con.close();

p.close();

rs.close();

} catch (SQLException e) {

JOptionPane.showMessageDialog(null, "数据库连接错误！", "错误",

JOptionPane.WARNING_MESSAGE);

} catch (NumberFormatException e) {

JOptionPane.showMessageDialog(null, "输入数据格式错误！", "错误",

JOptionPane.WARNING_MESSAGE);

}

refresh();

}

一月份的内容到此结束！