高分求纯JAVA代码源程序
private JButton getLoadBtn() {
if (LoadBtn == null) {
LoadBtn = new JButton();
LoadBtn.setBounds(new Rectangle(140, 225, 75, 30));
LoadBtn.setText("登陆");
LoadBtn.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
//如何写这的事件,使其可以用用户名:admin密码:admin
(用户名和密码我想在这里控制,只有这个用户,无其它用户)的用户登陆到另一界面下,让另一个类运行,并显示?
}
});
}
return LoadBtn;
}
以下程序如何连接数据库,并对其实现操作,可增加,查询,删除等?private JButton getAppBtn() {
if (AppBtn == null) {
AppBtn = new JButton();
AppBtn.setBounds(new Rectangle(50, 55, 105, 30));
AppBtn.setActionCommand("AppData");
AppBtn.setHorizontalTextPosition(SwingConstants.CENTER);
AppBtn.setText("增加记录");
AppBtn.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
//??
try{
AppData();
}catch(SQLException ex){
}
}
}); }
return AppBtn;
}
public void AppData() throws SQLException{
//????
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){}
Connection con=DriverManager.getConnection("jdbc:odbc:conn");
Statement stmt=con.createStatement();
//????
}
/**
* This method initializes jButton
*
* @return javax.swing.JButton
*/
private JButton getDelBtn() {
if (DelBtn == null) {
DelBtn = new JButton();
DelBtn.setBounds(new Rectangle(50, 155, 105, 30));
DelBtn.setActionCommand("DelData");
DelBtn.setHorizontalTextPosition(SwingConstants.CENTER);
DelBtn.setText("删除记录");
}
return DelBtn;
}
提供可实现的数据库操作的例子也行,要能运行,并通过的.
我
private JButton getLoadBtn() {
if (LoadBtn == null) {
LoadBtn = new JButton();
LoadBtn.setBounds(new Rectangle(140, 225, 75, 30));
LoadBtn.setText("登陆");
LoadBtn.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
//如何写这的事件,使其可以用用户名:admin密码:admin
(用户名和密码我想在这里控制,只有这个用户,无其它用户)的用户登陆到另一界面下,让另一个类运行,并显示?
}
});
}
return LoadBtn;
}
以下程序如何连接数据库,并对其实现操作,可增加,查询,删除等?private JButton getAppBtn() {
if (AppBtn == null) {
AppBtn = new JButton();
AppBtn.setBounds(new Rectangle(50, 55, 105, 30));
AppBtn.setActionCommand("AppData");
AppBtn.setHorizontalTextPosition(SwingConstants.CENTER);
AppBtn.setText("增加记录");
AppBtn.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
//??
try{
AppData();
}catch(SQLException ex){
}
}
}); }
return AppBtn;
}
public void AppData() throws SQLException{
//????
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){}
Connection con=DriverManager.getConnection("jdbc:odbc:conn");
Statement stmt=con.createStatement();
//????
}
/**
* This method initializes jButton
*
* @return javax.swing.JButton
*/
private JButton getDelBtn() {
if (DelBtn == null) {
DelBtn = new JButton();
DelBtn.setBounds(new Rectangle(50, 155, 105, 30));
DelBtn.setActionCommand("DelData");
DelBtn.setHorizontalTextPosition(SwingConstants.CENTER);
DelBtn.setText("删除记录");
}
return DelBtn;
}
提供可实现的数据库操作的例子也行,要能运行,并通过的.
我
// 不配置ODBC数据源,用JDBC-ODBC桥连接Access数据库,假设access在E:\\db1.mdb
Connection con;
Statement stmt;
try {
//Load JDBC driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//注意DBQ的写法
String url ="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=E:\\db1.mdb";
con = DriverManager.getConnection(url, "sa", "");
stmt = con.createStatement();
String query = "select * from perf";
ResultSet rs = stmt.executeQuery(query);
while ( rs.next() )
{
String str = rs.getString( "PE_PERF_NAME" );
System.out.print( str );
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
PE_PERF_NAME 是列名.
如果是增加createStatement之后的代码换成:
String query = "insert into perf(PE_PERF_NAME) values('111')";
executeUpdate(query);
删除query换成
String query = "delete perf where PE_PERF_NAME='111'";