SSM项目从零开始到入门002-创建第一个maven项目

来源：互联网发布：stringtokenizer java 编辑：程序博客网时间：2024/06/05 20:57

创建第一个maven项目

打开MyEclipse点击file -- New -- others --- 输入 maven 搜索

编辑pom.xml文件引入mysql驱动jar包

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">  <modelVersion>4.0.0</modelVersion>  <groupId>com.lcx.demo</groupId>  <artifactId>demo</artifactId>  <version>0.0.1-SNAPSHOT</version>    <dependencies><!-- MySql --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.32</version></dependency>  </dependencies>    <build/></project>

maven会自动加载mysql的jar包到当前的项目当中

创建JDBC例子测试

package com.lcx.jdbc;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class Jdbc {public static void main(String[] args) throws ClassNotFoundException, SQLException {//加载驱动Class.forName("com.mysql.jdbc.Driver");//建立连接String url = "jdbc:mysql://localhost:3306/mybatis";String user = "root";String password ="root";Connection conn = DriverManager.getConnection(url, user, password);//获取statament对象    执行sqlString sql = "select * from tb_user where id=?";PreparedStatement ps = conn.prepareStatement(sql);ps.setLong(1,1);//执行sql得到结果集ResultSet rs = ps.executeQuery();//处理结果集while (rs.next()) {System.out.println(rs.getString("name"));}//关闭结果集     关闭的顺序由里向外rs.close();//关闭预加载ps.close();//关闭连接conn.close();}}

阅读全文

0 0