Java连接mysql数据库

来源：互联网发布：java将xml转换成json 编辑：程序博客网时间：2024/06/06 19:48

import java.sql.*;//声明Connection对象 Connection con;//驱动程序名String driver = "com.mysql.jdbc.Driver";//URL指向要访问的数据库名mydataString url = "jdbc:mysql://127.0.0.1:33/test?useUnicode=true&characterEncoding=UTF-8//MySQL配置时的用户 String user = "root";//MySQL配置时的密码String password = "root";//遍历查询结果集try { //加载驱动程序 Class.forName(driver);//1.getConnection()方法，连接MySQL数据库！！   con = DriverManager.getConnection(url,user,password);  if(!con.isClosed())                                      System.out.println("Succeeded connecting to the Database!");                                      //2.创建statement类对象，用来执行SQL语句！！                                 Statement statement = con.createStatement();                                 //要执行的SQL语句//                                 String sql = "insert into demo(id,name,pos,salary) values(001,'水电费方','业务','1600') ";                             //String sql = "insert into demo(id,name,pos,salary) values(?,?,?,?) ";                             String sql = "insert into weather(address,temperature,weatherstatus,date) values(?,?,?,?) ";                                     PreparedStatement ps=null;                                      ps=con.prepareStatement(sql);                                 ps.setString(1,address);                                 ps.setString(2,temperature);                                 ps.setString(3,weather);                                     ps.setString(4,date);    con.close();                                 con.close();                            } catch(ClassNotFoundException e) {                                 //数据库驱动类异常处理                                 System.out.println("Sorry,can`t find the Driver!");                                e.printStackTrace();                                } catch(SQLException e) {                                 //数据库连接失败异常处理                                 e.printStackTrace();                                 }catch (Exception e) {                                 // TODO: handle exception                                 e.printStackTrace();                            }finally{                                System.out.println("数据库数据成功获取！！");                             }                     }

String url = “jdbc:mysql://127.0.0.1:33/test?useUnicode=true&characterEncoding=UTF-8 可以解决中文写入数据库乱码问题。建表时把编码方式设置为utf_8

阅读全文

0 0