在MySQL中添加表

王朝mysql·作者佚名  2008-05-31
窄屏简体版  字體: |||超大  

import Java.sql.Connection;

import java.sql.Statement;

import java.sql.DriverManager;

import java.sql.SQLException;

public class MainClass {

private static final String EMPLOYEE_TABLE = "create table MyEmployees3 ( "

+ " id INT PRIMARY KEY, firstName VARCHAR(20), lastName VARCHAR(20), "

+ " title VARCHAR(20), salary INT )";

public static Connection getConnection() throws Exception {

String driver = "org.gjt.mm.mysql.Driver";

String url = "jdbc:mysql://localhost/mydatabase";

String username = "root";

String passWord = "root";

Class.forName(driver);

Connection conn = DriverManager.getConnection(url, username, password);

return conn;

}

public static void main(String args[]) {

Connection conn = null;

Statement stmt = null;

try {

conn = getConnection();

stmt = conn.createStatement();

stmt.executeUpdate(EMPLOYEE_TABLE);

stmt.executeUpdate("insert into MyEmployees3(id, firstName) values(100, 'A')");

stmt.executeUpdate("insert into MyEmployees3(id, firstName) values(200, 'B')");

System.out.println("CreateEmployeeTableMySQL: main(): table created.");

} catch (ClassNotFoundException e) {

System.out.println("error: failed to load MySQL driver.");

e.printStackTrace();

} catch (SQLException e) {

System.out.println("error: failed to create a connection object.");

e.printStackTrace();

} catch (Exception e) {

System.out.println("other error:");

e.printStackTrace();

} finally {

try {

stmt.close();

conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

}

(出处:http://www.knowsky.com)

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有  導航