Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class Clientes
- {
- private static Scanner teclado = new Scanner(System.in);
- private static String db_host = "178.63.95.145";
- private static String db_user = "root";
- private static String db_pass = "2030xdc9h";
- private static String db_name = "clientes";
- private static Connection conexion;
- private static Statement st;
- public static void main(String[] args)
- {
- conectar();
- crearTablasDB();
- }
- private static void conectar()
- {
- try
- {
- Class.forName("com.mysql.jdbc.Driver");
- conexion = DriverManager.getConnection("jdbc:mysql://"+db_host+"/"+db_name,db_user, db_pass);
- st = conexion.createStatement();
- System.out.print("Conexión establecida con éxito.");
- }
- catch (Exception ex)
- {
- System.out.println("No hemos podido conectar con MySQL: "+ ex.getMessage());
- }
- }
- private static void crearTablasDB()
- {
- try
- {
- st.execute("CREATE TABLE IF NOT EXISTS 'clientes' ( 'cliente' VARCHAR(20) NOT NULL, 'dni' VARCHAR(9) NOT NULL ) ENGINE='InnoDB';");
- }
- catch (SQLException e)
- {
- System.out.println("No se ha podido crear la tabla: "+e.getMessage());
- }
- }
- private static void guardarClientes()
- {
- String nombreCliente;
- String dniCliente;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement