自学JAVA，MySQL数据库和Sqlite3简单代码

自学java中。简单学习了数据库操作。。

MySQL数据库操作

import java.sql.*;
public class Test
{
        public static void main(String args[]) throws Exception
        {
                Class.forName("com.mysql.jdbc.Driver");
                String url="jdbc:mysql://127.0.0.1:3306/wy";
                Connection con=DriverManager.getConnection(url,"root","root");
                Statement st=con.createStatement();
                String sql="select * from shun_goods where id<'20'";
                ResultSet rs=st.executeQuery(sql);
                ResultSetMetaData rsmd = rs.getMetaData();
                while(rs.next())
                {
                        System.out.println("----------------------------------");
                        System.out.println("ID:"+ rs.getString("id")+ 
                        " | 商品名:" + rs.getString("goods_show_name"));
                        System.out.println("----------------------------------");
                }
        }
}

Sqlite3数据库操作。。。

import java.sql.*;
public class JSqlite3
{
        public static void main(String args[]) throws Exception
        {
                Class.forName("org.sqlite.JDBC");
                Connection con=DriverManager.getConnection("jdbc:sqlite:mydb2.db");
                Statement st=con.createStatement();
                String sql="select * from user";
                ResultSet rs = st.executeQuery(sql);
                while ( rs.next() )
            {
                    int id = rs.getInt("id");
                    String name=rs.getString("name");
                    String sex=rs.getString("sex");
                    System.out.println("ID:"+id);
                    System.out.println("姓名:"+name);
                    System.out.println("性别:"+sex);
                    System.out.println();
                }
                rs.close();
                st.close();
        }
}