Package zmsjdbc; import java.sql. *; public class mysql1 {
Private string url = "jdbc: mysql: // localhost: 3306 / beyond"; // download mysql driver mm.mysql-2.0.4-bin.jar is placed in d: /jbuilder9/jdk1.4/jre/lib/ under EXT
Private string user = "root"; private string pwd = ""; public connection getcon () {connection con; "org.gjt.mm.mysql.driver"). NewInstance ( ); // Create connection Con = DriverManager.getConnection (URL, User, PWD); Return Con;
Catch (classnotfoundexception e) {system.out.println ("Load Driver Error");
Catch (Exception E) {system.out.println ("a big error in the event");
Return null;} public resultSet Executesql (String Sqlstr) {Connection Conn; St.
Try {conn = getCon (); stmt = conn.createstatement (); resultset = stmt.executeQuery (SQLSTR);
Return RS;} catch (sqlexception e) {system.out.print ("Errors when getting data set");} return null;}
Public static void main (string [] args) {mysql1 mysql11 = new mysql1 (); connection conn; result set; rs = mysql11.executesql ("select * from zms1"); try {whele (rs.next ()) { System.out.println ("name"));}}}}} catch (exception e) {system.out.println (E.getMessage ());}
}
}
