String dirverName = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "JDBC:ODBC:YourDSN";
Class.forName (dirverName);
Connection conn = DriverManager.getConnection (url);
String url = "JDBC:ODBC:YourDSN";
Class.forName (dirverName);
Connection conn = DriverManager.getConnection (url);
import org.gjt.mm.mysql.Driver;
public class JDBCTry {
public static void main(String args[]) throws SQLException{
new Driver();
String url="jdbc:mysql://127.0.0.0/test";
Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();
String sql="select * from Customer";
ResultSet re=stmt.executeQuery(sql);
while(re.next()) {
String ssn=re.getString("SSN");
String name=re.getString("cust_name");
String add=re.getString("address");
System.out.println(ssn+";"+name+";"+add);
}
for (int j=4978011;j<4978020;j++) {
String sql2="insert into Customer values (\""+j+"\",\"刘敏\",\"neusoft\")";
ResultSet re2=stmt.executeQuery(sql2);
}
String sql2="delete from Customer where cust_name=\"刘敏\"";
ResultSet re2=stmt.executeQuery(sql2);
con.close();
stmt.close();
}
}
URL是"JDBC:ODBC:DataDSN"DataDSN是你建库时的数据源的名字。