java数据库基础(mysql)1

来源：互联网发布：midi制作软件mac 编辑：程序博客网时间：2024/06/05 08:33
package com.xasmall.sql;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;  public class Demo1 {      public static final String url = "jdbc:mysql://127.0.0.1/user";      public static final String name = "com.mysql.jdbc.Driver";      public static final String user = "root";      public static final String password = "root";      public static Connection conn=null;    public Demo1() throws ClassNotFoundException, SQLException {        Class.forName(name);        conn=DriverManager.getConnection(url,user,password);    }    //Statement    public void exe1() throws SQLException {        Statement con=conn.createStatement();        String sql="insert into student values('37932747','张元')";//      String id="16281137";//      String name="张元";//      String sql="insert into student values('"+id+"','"+name+"')";        con.execute(sql);        con.close();    }    //PreparedStatement    public void exe2() throws SQLException {        String sql="Select *from student";        PreparedStatement ps=conn.prepareStatement(sql);        ResultSet rs=ps.executeQuery();        System.out.println("id"+"--------"+"name");        while(rs.next()){            System.out.println(rs.getString(1)+"----"+rs.getString(2));        }        ps.close();    }    //占位符    public void exe3() throws SQLException {        String sql="insert into student(id,name) values(?,?)";        PreparedStatement ps=conn.prepareStatement(sql);        ps.setObject(1, "379181930");        ps.setObject(2, "原子");        ps.execute();        ps.close();    }    public static void main(String[] args) throws ClassNotFoundException, SQLException {        Demo1 test1=new Demo1();        test1.exe1();        test1.exe2();        test1.exe3();    }}
阅读全文
0 0