Java method for accessing mysql database, javamysql Database

Source: Internet
Author: User

Java method for accessing mysql database, javamysql Database

1. Download the interface package mysql-connector-java-5.0.8-bin.jar

2. Programming

(1) load the driver

(2) programming connection operations

(3) return result Processing


Programming example

import java.sql.*;public class Access2Database{public Connection getConn(){Connection conn=null;try{Class.forName("com.mysql.jdbc.Driver");String url="jdbc:mysql://localhost:3306/mytest";String user="root";String password="111";conn=DriverManager.getConnection(url, user, password);if(conn!=null){System.out.println("The connection to database is successful!");}}catch(Exception e){e.printStackTrace();}return conn;}public ResultSet getResultSet(Statement stam,String sql){ResultSet res=null;try {res=stam.executeQuery(sql);} catch (SQLException e){e.printStackTrace();}return res;}void showResultSet(ResultSet res){}}
import java.sql.*;public class GetConnection{public static void main(String[] args){Access2Database adb=new Access2Database();Connection conn=adb.getConn();Statement stam=null;try {stam = conn.createStatement();} catch (SQLException e1) {e1.printStackTrace();}//show resultsetString sql="select * from student;";ResultSet res=adb.getResultSet(stam, sql);try {System.out.println("name\tmajor\tscore");while(res.next()){String name,major;int score;name=res.getString(1);major=res.getString(2);score=res.getInt(3);System.out.println(name+"\t"+major+"\t"+score);}} catch (SQLException e) {e.printStackTrace();}try{res.close();}catch(SQLException e){e.printStackTrace();}//insert something into tablesql="insert into student(name,major,score) values('f','Chinese','70');";try {stam.execute(sql);} catch (SQLException e) {e.printStackTrace();}//delete something from the tablesql="delete from student where name='f';";try{stam.executeUpdate(sql);}catch(SQLException e){e.printStackTrace();}//change the data int the tablesql="update student set score=100 where name='a' and major='Chinese'";try{stam.executeUpdate(sql);}catch(SQLException e){e.printStackTrace();}//prepared statementsql="select * from student where name=?";PreparedStatement pstam=null;try {pstam=conn.prepareStatement(sql);pstam.setString(1, "a");res=pstam.executeQuery();System.out.println("**********************");while(res.next()){String name,major;int score;name=res.getString(1);major=res.getString(2);score=res.getInt(3);System.out.println(name+"\t"+major+"\t"+score);}} catch (SQLException e) {e.printStackTrace();}//release the resource of the programtry{res.close();pstam.close();stam.close();conn.close();}catch(SQLException e){e.printStackTrace();}}}
Adjust the code as needed

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.