這個很簡單,當提交表單後把賬號與密碼寫入數據庫就行了!
寫一個javabean,再傳入新增數據的sql語句就可以了!
package ipscan;import java.sql.*;public class Jdbc {
private String ID="";
private String IP="";
private String HostName="";
private String GroupName="";
private String UserName="";
private String MACAddress="";
private String autodate="";
private String sql = ""; public Jdbc() {
}
public String getID()
{
return this.ID;
}
public String getIP()
{
return this.IP;
}
public String getHostName()
{
return this.HostName;
}
public String getGroupName()
{
return this.GroupName;
}
public String getUserName()
{
return this.UserName;
}
public String getMACAddress()
{
return this.MACAddress;
}
public String getautodate()
{
return this.autodate;
} public void DBCon(String sql){
if (sql.length() != 0)
{
this.sql = sql;
//System.out.println("sql=" + sql);
}
else
{
//System.out.println("請輸入sql語句!");
System.exit(0);
}
Connection con = null;
Statement stmt = null;
ResultSet rs = null; try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(Exception e){
//System.out.println("odbc driver加載失敗!");
}
try{
con = DriverManager.getConnection("jdbc:odbc:ip","","");
stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
boolean isQuery = stmt.execute(sql);
if (isQuery){
rs = stmt.executeQuery(sql);
while (rs.next()){
ID = rs.getString(1);
IP = rs.getString(2);
HostName = rs.getString(3);
GroupName = rs.getString(4);
UserName = rs.getString(5);
MACAddress = rs.getString(6);
autodate = rs.getString(7);
}
}
else{
//stmt.executeUpdate(sql);
//System.out.println("操作資料庫成功!");
}
//關閉與資料庫的連接
con.close();
}
catch (Exception e){
System.out.println(e.getMessage());
}}
}
寫一個javabean,再傳入新增數據的sql語句就可以了!
package ipscan;import java.sql.*;public class Jdbc {
private String ID="";
private String IP="";
private String HostName="";
private String GroupName="";
private String UserName="";
private String MACAddress="";
private String autodate="";
private String sql = ""; public Jdbc() {
}
public String getID()
{
return this.ID;
}
public String getIP()
{
return this.IP;
}
public String getHostName()
{
return this.HostName;
}
public String getGroupName()
{
return this.GroupName;
}
public String getUserName()
{
return this.UserName;
}
public String getMACAddress()
{
return this.MACAddress;
}
public String getautodate()
{
return this.autodate;
} public void DBCon(String sql){
if (sql.length() != 0)
{
this.sql = sql;
//System.out.println("sql=" + sql);
}
else
{
//System.out.println("請輸入sql語句!");
System.exit(0);
}
Connection con = null;
Statement stmt = null;
ResultSet rs = null; try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(Exception e){
//System.out.println("odbc driver加載失敗!");
}
try{
con = DriverManager.getConnection("jdbc:odbc:ip","","");
stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
boolean isQuery = stmt.execute(sql);
if (isQuery){
rs = stmt.executeQuery(sql);
while (rs.next()){
ID = rs.getString(1);
IP = rs.getString(2);
HostName = rs.getString(3);
GroupName = rs.getString(4);
UserName = rs.getString(5);
MACAddress = rs.getString(6);
autodate = rs.getString(7);
}
}
else{
//stmt.executeUpdate(sql);
//System.out.println("操作資料庫成功!");
}
//關閉與資料庫的連接
con.close();
}
catch (Exception e){
System.out.println(e.getMessage());
}}
}
是不是可以读出数据库,将提交的密码与数据库的比较,
对就可以继续
否则的话就over了,只是这个代码我写不出来,
昨天我写了一个出了点问题,我不知道问题到底出哪了