資源簡介
科研管理系統 java swing mysql
代碼片段和文件信息
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.SQLException;
import?javax.swing.JOptionPane;
/**
?*
?*?@author??__USER__
?*/
public?class?Connect?extends?javax.swing.JDialog?{
private?String?url;
/**?Creates?new?form?Connect2?*/
public?Connect(java.awt.frame?parent?boolean?modal)?{
super(parent?modal);
initComponents();
}
public?String?getConn()?{
String?Database_URL?=?“jdbc:mysql://localhost/scim?user=root&password=root&useUnicode=true&characterEncoding=utf8“;
StringBuffer?url?=?new?StringBuffer(“jdbc:mysql://“);
if?(txtUrl.getText().equals(““))?{
JOptionPane.showMessageDialog(this?“請填寫數據庫URL“);
return?null;
}?else
url.append(txtUrl.getText()?+?“:“);
if?(txtPort.getText().equals(““))?{
JOptionPane.showMessageDialog(this?“請填寫數據庫端口“);
return?null;
}?else
url.append(txtPort.getText()?+?“/“);
if?(txtDatabase.getText().equals(““))?{
JOptionPane.showMessageDialog(this?“請填寫數據庫名稱“);
return?null;
}?else
url.append(txtDatabase.getText()?+?“?user=“);
if?(txtUsername.getText().equals(““))?{
JOptionPane.showMessageDialog(this?“請填寫用戶名“);
return?null;
}?else
url.append(txtUsername.getText()?+?“&“);
if?(!txtpsw.getText().equals(““))
url.append(“password=“?+?txtpsw.getText()?+?“&“);
url.append(“useUnicode=true&characterEncoding=utf8“);
String?sql?=?“select?*?from?users“;
try?{
String?JDBC_DRIVER?=?“com.mysql.jdbc.Driver“;
Class.forName(JDBC_DRIVER);
Connection?conn;
conn?=?DriverManager.getConnection(url.toString());
conn.close();
}?catch?(SQLException?e)?{
JOptionPane.showMessageDialog(this?“數據庫連接失敗“);
return?null;
}?catch?(ClassNotFoundException?e)?{
JOptionPane.showMessageDialog(this?“找不到合適的驅動程序,請用mysql數據庫“);
}
return?url.toString();
}
/**?This?method?is?called?from?within?the?constructor?to
?*?initialize?the?form.
?*?WARNING:?Do?NOT?modify?this?code.?The?content?of?this?method?is
?*?always?regenerated?by?the?Form?Editor.
?*/
//GEN-BEGIN:initComponents
//?
private?void?initComponents()?{
jLabel6?=?new?javax.swing.JLabel();
jButton1?=?new?javax.swing.JButton();
jButton2?=?new?javax.swing.JButton();
jLabel4?=?new?javax.swing.JLabel();
jLabel1?=?new?javax.swing.JLabel();
jLabel5?=?new?javax.swing.JLabel();
jLabel2?=?new?javax.swing.JLabel();
jLabel3?=?new?javax.swing.JLabel();
txtUrl?=?new?javax.swing.JTextField();
txtPort?=?new?javax.swing.JTextField();
txtDatabase?=?new?javax.swing.JTextField();
txtUsername?=?new?javax.swing.JTextField();
txtpsw?=?new?javax.swing.JPasswordField();
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
jLabel6.setFont(new?java.awt.Font(“宋體“?0?14));
jLabel6.setForeground(new?java.awt.Color(255?0?51));
jLabel6
.setText(“\u6570\u636e\u5e93\u8fde\u63a5\u5931\u8d25\u
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????552??2009-04-20?20:12??sci_research\.classpath
?????文件????????388??2008-12-11?18:49??sci_research\.project
?????文件????????469??2009-02-05?20:41??sci_research\.springBeans
?????文件???????2525??2009-05-25?19:24??sci_research\bin\databa
?????文件???????2470??2009-05-25?18:16??sci_research\bin\databa
?????文件???????3027??2009-05-25?18:43??sci_research\bin\databa
?????文件???????1473??2009-05-25?19:26??sci_research\bin\databa
?????文件???????2275??2009-05-25?18:16??sci_research\bin\databa
?????文件???????2244??2009-05-25?18:27??sci_research\bin\databa
?????文件????????706??2009-05-25?18:16??sci_research\bin\logic\deptModel.class
?????文件????????672??2009-05-25?18:16??sci_research\bin\logic\manage$1.class
?????文件???????1501??2009-05-25?18:16??sci_research\bin\logic\manage$2.class
?????文件????????932??2009-05-25?18:16??sci_research\bin\logic\manage$3.class
?????文件????????836??2009-05-25?18:16??sci_research\bin\logic\manage$4.class
?????文件???????1098??2009-05-25?18:16??sci_research\bin\logic\manage$5.class
?????文件???????1098??2009-05-25?18:16??sci_research\bin\logic\manage$6.class
?????文件????????834??2009-05-25?18:16??sci_research\bin\logic\manage$7.class
?????文件????????892??2009-05-25?18:16??sci_research\bin\logic\manage$8.class
?????文件????????711??2009-05-25?18:16??sci_research\bin\logic\manage$9.class
?????文件???????2945??2009-05-25?18:16??sci_research\bin\logic\manage.class
?????文件???????1914??2009-05-25?18:16??sci_research\bin\logic\model.class
?????文件????????721??2009-05-25?18:16??sci_research\bin\logic\pdtModel.class
?????文件????????972??2009-05-25?18:16??sci_research\bin\logic\prjlayout.class
?????文件????????711??2009-05-25?18:16??sci_research\bin\logic\prjModel.class
?????文件????????898??2009-05-25?18:16??sci_research\bin\logic\prj_psnModel.class
?????文件????????781??2009-05-25?18:16??sci_research\bin\logic\psnModel.class
?????文件????????557??2009-05-25?18:16??sci_research\bin\main$1.class
?????文件????????559??2009-05-25?18:16??sci_research\bin\main$2.class
?????文件????????557??2009-05-25?18:16??sci_research\bin\main$3.class
?????文件????????557??2009-05-25?18:16??sci_research\bin\main$4.class
............此處省略119個文件信息
評論
共有 條評論