JDBC连接MySQL数据库

小咪咪 2024-04-26 10:36 79阅读 0赞

> 使用JDBC连接MySQL数据库在Java中是十分常见的操作，直接贴代码好了

import java.sql.Connection;
    import java.sql.DriverManager;
    //用来获取数据库连接的类
    public class Dao {
        
        private static final String URL="jdbc:mysql://localhost/qq";
        private static final String USER="root";
        private static final String PASSWORD="qwer";
    
        Connection conn=null;
        //获取连接
        public Connection getConn() throws Exception
        {
            //1.加载驱动程序
            Class.forName("com.mysql.jdbc.Driver");
            //2.获得数据库连接
            conn= DriverManager.getConnection(URL,USER,PASSWORD);
            //操作数据库
            return conn;    
        }
    }

> 通过Dao类获取连接，然后初始化

Dao d=new Dao();
                    Connection conn=null;
                    Statement stemt=null;
                    ResultSet rs=null;
                    try {
                        conn=d.getConn();
                    } catch (Exception e1) {
                        // TODO Auto-generated catch block
                        e1.printStackTrace();
                    }
                    String sql="Select * from student where StuNum=admin;";
                    try {
                        stemt=conn.createStatement();
                        rs = stemt.executeQuery(sql);
                        while(rs.next())  {         
                            // 选择Name这列数据     
                            String StuNum = rs.getString("StuNum");  
                            String StuName = rs.getString("StuName");  
                            String StuSex= rs.getString("StuSex");
                            String StuGrade= rs.getString("StuGrade");
                            String StuMajor= rs.getString("StuMajor");
    
                            String out="学号:"+StuNum+"\n姓名:"+StuName+"\n性别:"+StuSex+"\n成绩:"
                                    +StuGrade+"\n专业:"+StuMajor;
                            jta.setText(out);
                     }  
                    } catch (SQLException e1) {
                        // TODO Auto-generated catch block
                        e1.printStackTrace();
                    }

> 另外，还用部分关于Statement和PreparedStatement的区别，以及PreparedStatement如何防止SQL注入，参考这篇博客  
> [http://www.importnew.com/5006.html][http_www.importnew.com_5006.html]  
> 翻译： ImportNew.com - 刘志军  
> 原文连接：[http://javarevisited.blogspot.com/2012/03/why-use-preparedstatement-in-java-jdbc.html\#ixzz2YjEhPIis][http_javarevisited.blogspot.com_2012_03_why-use-preparedstatement-in-java-jdbc.html_ixzz2YjEhPIis]

[http_www.importnew.com_5006.html]: http://www.importnew.com/5006.html
[http_javarevisited.blogspot.com_2012_03_why-use-preparedstatement-in-java-jdbc.html_ixzz2YjEhPIis]: http://javarevisited.blogspot.com/2012/03/why-use-preparedstatement-in-java-jdbc.html#ixzz2YjEhPIis