JDBC 访问数据库

来源:互联网 发布:淘宝的驱鼠器有用吗 编辑:程序博客网 时间:2024/05/19 02:20
public class JdbcTest {private static  String url = "jdbc:mysql://localhost:3306/test";private static String username = "root";private static String password = "1234";static {try {Class.forName("com.mysql.jdbc.Driver");//加载驱动类DriverManager.registerDriver(new Driver());//注册驱动} catch (Exception e) {e.printStackTrace();}}public static void saveMonkey(Monkey monkey) {Connection con = null;try {con = DriverManager.getConnection(url, username, password);Statement st = con.createStatement();st.executeUpdate("insert into monkey (name,age,gender)values('"+ monkey.getName() + "','" + monkey.getAge() + "','"+ monkey.getGender() + "')");st.close();} catch (Exception e) {e.printStackTrace();} finally {if (con != null) {try {con.close();} catch (Exception e) {e.printStackTrace();}}}}public static void main(String[] args) {Monkey monkey = new Monkey();monkey.setName("jack");monkey.setAge(4);monkey.setGender('w');saveMonkey(monkey);}}

原创粉丝点击